How can I echo variable ordered by something

Question

I created a table that contains message, sender, to, time I want to echo message ordered by time that is my code.

$query= mysql_query("SELECT * FROM  `table` GROUP BY `sender` ORDER BY `time` DESC")or die(mysql_error());
while($arr = mysql_fetch_array($query)){
$num = mysql_num_rows($query);
$msg = $arr ['message'];
echo '</br>';
echo $msg;
}

that shows me the first message from each sender I want to show the last message from each sender, So how can I do this

Thanks :)
Klaus

It shows not first but "*some*" message from each sender. It's not guaranteed to be the first. — zerkms, Jul 01 '13 at 01:25

Daniel Robertus · Accepted Answer · 2013-07-01T02:28:17.257

1

try this :

SELECT * FROM  (select * from table order by `time` desc) t1 GROUP BY `sender`

edited Jul 01 '13 at 02:28

answered Jul 01 '13 at 01:35

Daniel Robertus

1,100
1
11
24

that shows me this error `Every derived table must have its own alias` – Klaus Jasper Jul 01 '13 at 02:03
sorry missing alias.. i did some edit.. try again – Daniel Robertus Jul 01 '13 at 02:30
Thanks!! But the Order not working why? sorry if I disturbed you. – Klaus Jasper Jul 01 '13 at 03:14
it also order, but from alias table. i believe if you group by it will show first data they found from the table. I didn't know exact reason, sorry.. – Daniel Robertus Jul 01 '13 at 03:20

How can I echo variable ordered by something

1 Answers1