MySQL: Request to select the last 10 send/received messages to/by different users
- by Yako malin
I want to select the 10 last messages you received OR you sent TO different users.
For example the results must be shown like that:
1. John1 - last message received 04/17/10 3:12
2. Thomy - last message sent 04/16/10 1:26
3. Pamela - last message received 04/12/10 3:51
4. Freddy - last message received 03/28/10 9:00
5. Jack - last message…