Your example query says it uses the "books" table and the field for the
username is "book_username", your query is searching User.username
$this->Book->find('all', array('conditions' => array('Book.book_username' =>
$username)));
Where $username contains the condition.
On 16 March 2011 04:04, cakebaker <[email protected]> wrote:
> I am trying to run cakephp find query for the following sql query:
> $sql=select * from books where book_username='this->$username'";
>
> $this->Book->find('all',array('conditions'=>
> array('User.username'=>'myName'),'fields'=>'Book.name','order'=>
> 'Book.id ASC','limit'=>10,'recursive'=>0));
>
> what is wrong with my code?? I put this code in BookController?? Am I
> right?
> please suggest me
> TIA
>
> --
> 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
>
--
Kind Regards
Stephen
http://www.ninjacodermonkey.co.uk
--
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
