I'm not sure if I'm missing something here. I'm trying to come up with
this sql statement the Cakephp way:
select * from practitioners where name like 'Vermeulen' or surname
like 'Vermeulen';
This is what I've come up with:
find( 'all', $conditions = array("OR"=>array('Practitioner.surname
LIKE' => "%"Vermeulen"%",'Practitioner.name LIKE' =>
"%"Vermeulen"%")));
This works but it only outputs the whole database. I just want it to
output practitioners with surnames or names like Vermeulen.
Please help, 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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
