subquery and unionall
hi, Anyone knows a good way to make UNION query in CakePHP? I would like to avoid using $this->query();. for this code => "Select distinct bm.id,name, add From table1 bm, (Select id bid, count(id) cnt from table2 where status = 'N' group by id union all Select id bid, count(id) cnt from table3 where status = 'N' group by id order by cnt limit 10) ab Where id = bm.id" -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
sub query and union all function in cakephp
hi, can we do subquery and union all functions of mysql in cakephp? i need to query that in my sample app, so any one help me, Thanks in advance Shiva -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: display last 5 inserted image
@phpMagpie: i am new to cakephp,so i didn't help u.. sorry for that.. i will try to help u Thanks, Shiva -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
tab display in layout in problem
hi, I added [newly added book] tab for my app, still i need to display one more tab below this tab, that tab name is [Most popular book].i used the same css for this tab also, but it's not working for me.it's tab is overlap to the previous one, any one can help me to fix this Thanks in advance, Shiva -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Very strange behaviour of CAKEPHP on login
hi, I added [newly added book] tab for my app, still i need to display one more tab below this tab, that tab name is [Most popular book].i used the same css for this tab also, but it's not working for me.it's tab is overlap to the previous one, any one can help me to fix this Thanks in advance, Shiva -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: display last 5 inserted image
Hi, I need to create the multitab tab using css in cakephp, How to create that in cakephp Thanks in advance, shiva -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: display last 5 inserted image
hi, I need to display the tickercontent.txt content in template of cakephp using javascript,any one can help me to fix the problem -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: display last 5 inserted image
hi , i used tab to mention some images, i need to display some other kind of images in another tab,how can i add that? -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: display last 5 inserted image
hi, > can we set the size of the images which displayed in the template, any one can help me,please? -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
display last 5 inserted image
hi, i need to display last five inserted image, anyone can help me to fix this problem -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: image insertion
hi, my code n template: foreach($bookid as $id){ // echo 'book image path:'.$id['Book']['front_page']; $imgpath = $id['Book']['front_page']; // echo $imgpath; echo ''; echo ''; echo ''; echo ''; echo ''; echo $id['Book']['book_name'].''; echo ''; -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: image insertion
hi, Thanks for the reply, I tried the both, but no use. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
image insertion
hi, i save the image path in mysql field.i get that path in controller and send it to template to print the image by using $html->image($path), but this one is not working for me, so anyone can help to fix this problem Thanks in advance, shiva -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
last inserted id
hi' I need to retrive data from last inserted id, how to get the last inserted id from mysql database... -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
how to fetch image from db
hi, I need to display image which is in the database,i save image path in that field.how to fetch the image from the image directory path and display in the index page of the application.. Thanks in advance shiva, -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
dbo_mysql.php error
hi guys, Iam begi to cake php, i try to run some sample cake php app.it shows error like this [Fatal error: Call to undefined function mysql_query() in D: \nasoindiadev\tra2\cake\libs\model\datasources\dbo\dbo_mysql.php on line 600]. any one can help me to fix this .. thanks in advance -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: How come this isn't a safe way to store username and passwords
Thanks for your replay.please bring some example code to run -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php