Hello, good evening. I think the title is a bit confusing, I'll try to explain it better.
I'm doing a chat system and I'm wanting to list all user conversations, but only one message from each user.
Example: ItisshowingallmessagesfromtheuserMatthew,butIwantedtoshowonlyone.
MyDB:
My select
SELECT * FROM pw_chat ORDER BY data ASC