Remove the quotes. suburb1 ='2'"
On Mon, Jul 16, 2012 at 1:00 PM, Ditshwanelo <[email protected]>wrote: > This is my query,i dnt knw wat is wrong it was working nd nw it returns > null > $search_query=$this->Suburb->query("SELECT suburbs.*, matchsuburbs.* FROM > matchsuburbs LEFT JOIN suburbs ON matchsuburbs.suburb2 = suburbs.id WHERE > matchsuburbs.suburb1 ='2'"); > print_r($search_query); > returns empty array > > -- > 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 > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- *Regards -- Soumavo Chattaraj Sr. Application Programmer | Web Spiders * -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
