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 thats what the join is on.

I am doing it in my messages controller so it would need to be something like:

$this->Message->find(); 

Thanks

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