$distinctBookCategories = $this->Book->find('list',array(
'fields'=>array('category_id'),
'conditions'=>array(
'NOT'=>array('category_id'=>null),
'{Other book conditions go here}'
),
'group'=>'category_id'
));
I am not sure what you are looking to do here. But this is the code I use
to pull unique ids.
Then you can loop through them, and save them to what ever table you want.
Happy Coding.
--
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