php - MYSQL - FInd last date and group by IDUSER -
this question has answer here: get latest date grouped mysql data 7 answers i have message system on site , see list of users sent me message while displaying last message of each user. same way facebook. so, have table idusersender, iduserreceiver, date , message i tried on several time take query can not have last message of each. idea? ok, again, try please select message my_table iduserreceiver = 'my_id' , date in (select max(date) my_table group idusersender);