Hi guys, I am at the tail end of a big site I am building and am trying to figure the best way to accomplish the messaging system. Basically it will act like the standard social network system. You click 'send message' on someones profile, go to a page that has a title field and a text field, enter your message and press sybmit. This is where I need some guidence. I figure to have a thread table and have the fields id (autoincrement message id), to id, from id, message, timestamp. I need it to act like a conversation. Someone writes and sends, the person gets an alert saying they have a message and looks at it, they then reply, the first person then gets a message and it says on the message page the message with a (replied) or (unread), i want them to be able to go to their message page and see what they have replied to and whats new. Also, I feel there is a much more eficient way of doing the database table. Any advice?
|