Saturday, April 26, 2014

Subqueries, how to do this correctly?

Hi,

I have two tables, one Submits, the other Categories. Submits has a column called category_id which is linked to the id of Categories. I want to access the name field from Category and return it, all in one query. how can I do this in CakePHP. Normally I'd make a virtual table and select all from there.

I'm new to CakePHP, first project and liking it so far! :)

./cake bake all (is the shizz)

Cheers.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: