Select only one latest message from every distinct sender in php

Asked Mar 05 '17 at 08:36

Active Mar 05 '17 at 09:10

Viewed 233 times

I'm developing a site and I need a way of selecting only one newest message from the database and show to the current user like in facebook.

When the user clicks on the message, then the rest of the messages (if any) are loaded. Here is the database query photo:

How do I make only one message from e.g sender 75e928ac97dd17360a7890d6 to be rendered to recipient AmoloCaleb?

UPDATE: Thi is the sql code:

$stmt = "SELECT  msg,sender FROM chat WHERE sender IN (SELECT DISTINCT sender from chat WHERE recipient=?)";

edited Mar 05 '17 at 09:10

asked Mar 05 '17 at 08:36

Caleb Amolo

provide the `php` code you are using to query the database – muya.dev Mar 05 '17 at 08:49
@kikuyu1 done that – Caleb Amolo Mar 05 '17 at 09:11
So you want the latest message per sender? This question is asked endlessly on this forum. Occasionally, it's correctly answered too. – Strawberry Mar 05 '17 at 09:37
@Strawberry could you please cite one because so far,all I've seen doesn't suffice – Caleb Amolo Mar 05 '17 at 09:43
add limit and orderby to your query – bxN5 Mar 05 '17 at 10:40
Please see [Select row with most recent date per user](http://stackoverflow.com/q/17038193/2298301) – Dhruv Saxena Mar 05 '17 at 10:50
thanks @DhruvSaxena – Caleb Amolo Mar 05 '17 at 11:13

0 Answers0