KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Hi, I need to do the following query using the CakePHP find method: SELECT * FROM `messages` INNER JOIN users ON messages.from = users.id WHERE messages.to = 4 ORDER BY messages.datetime DESC Basically I have: messages table with a Message model users table with User model and want to retrieve information from both tables in one query. The users.id field is the same as the messages.from field, so that's what the join is on. I am doing it in my MessagesController so it would need to be something like: $this->Message->find(); Thanks
Tags (comma-separated)
Save Edits
Cancel