cakephp retrieving multiple values in a column

Question

I want to retrieve multiples values from a field. the code I am using this this

$conditions = array('Tag.name'=>$compare);//$compare = array('value1', 'value2',..);
$values = $this->find('all', array('conditions' => $conditions));

But It keeps coming out like this

    SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`count` FROM `tags` AS `Tag` WHERE `Tag`.`name` IN ('tag2', ' tag1', ' one tag')

Problem is it only retrieves the first value given. instead of all the values . How do I get it to select all the values in the array.

Are you sure there are 'tag2', ' tag1', ' one tag' tags in your tags table? Paste the var_dump($values); print out back here. — neilcrookes
– neilcrookes, Commented Nov 6, 2009 at 20:32

David Yell · Accepted Answer · 2009-12-24 15:01:45Z

2

What version of Cake are you using?

But the main thing is that your conditions needs to be in a fields array.

find('all', array(
'conditions' => array('name' => 'Thomas Anderson'),
'fields' => array('name', 'email'),
'order' => 'field3 DESC',
'recursive' => 2,
'group' => 'type'
));

Ref, Model::find() API Docs

The reason your query is not working is that you need to move it into that pattern..

So your query would be,

$compare = array('value1', 'value2');
$values = $this->Model->find('all', array('fields' => $compare));

Not sure on your example if you meant to omit it, but always best to include the model you are running the find against :)

answered Dec 24, 2009 at 15:01

David Yell

11.9k13 gold badges64 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cakephp retrieving multiple values in a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related