Re: cakephp Messaging sysytem

I have a simplified messaging system.

User
Message
MessageRecipient
MessageSender

doesn't support composing to multiple users or threaded conversations, works fine as a simple system.

On 24 February 2011 01:26, Josh <joshabbe@gmail.com> wrote:

So to generate a user's "inbox", I'm guessing you would select all of the conversation_id's from the conversation_users table and save them to an array.  Then you would select the messages from the messages table where the conversation_id is in the array you made that contains all of the conversation_id's for the current user and where the sender is not the current user.  You group by conversation_id and choose the highest message.id from the group to be the message to display in the inbox.

At least that's my guess as to how you would do it.  Is there a better way?

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

--
Kind Regards
 Stephen

 http://www.ninjacodermonkey.co.uk

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php