samedi 25 avril 2015

How to get messages from MySQL database and print them in groups determined by Sender?


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