AerolaAbrasia
New Member
I am stuck with the following query, which won't order by it's date. Any help, or insight into what I am doing wrong will be much appreciated. The query is supposed to get an entry by thread_id, and then show the newest post in the thread, much like with a forum post, which it does fine. But when I try to order the results from newest to oldest using ORDER BY clause, it seems to ignore it.\[code\]$query = "SELECT * FROM messages WHERE (thread_id, received) IN (SELECT thread_id, MAX(received) FROM messages WHERE receiver='$user' OR sender='$user' AND is_hidden_receiver!='1' GROUP BY thread_id) ORDER BY received DESC";\[/code\]Cheers, Lea