Say I have a table in MySQL database: id, msgto, msgfrom, message, date.
id = just message of it.
msgto = user ID who the message belongs to.
msgfrom = From whom the message is.
message = Message itself.
date = date of message.
So I want to make message system and display it as threads, so SELECT * FROM messages WHERE msgto=[current users ID]
Then I want to have messages grouped to sections/arrays like based on msgfrom variable.
So say there are 15 messages with msgfrom=5 and msgto=[current user] So basically there are 15 messages from user with ID of 5, how can I basically have them grouped and printed out in ID descending order (newest first)?
End result should be like:
message 4 from user1
message 3 from user1
message 2 from user1
message 1 from user1
[new group]
message 3 from user2
message 2 from user2
message 1 from user2
Printed in PHP by the way.
Aucun commentaire:
Enregistrer un commentaire