Running a query with PHP/MySQL then reordering the results by another column?

Use a subquery to reorder: SELECT * FROM ( SELECT * FROM post INNER JOIN account ON post. Account_id = account. Account_id WHERE post_id > neww ORDER BY post_date ASC LIMIT 10; ) ORDER BY post_id.

Thanks worked like a charm, I cant believe I have been searching 2 days for this :(... – Cody. Stewart Mar 1 '10 at 22:28 Thanks, I thought that this would be the way to go with my own problem (On SQL Server 2k8). You've confirmed it for me.

+1 – sholsinger Sep 24 '10 at 15:42.

Use a subquery: SELECT * FROM ( SELECT * FROM post INNER JOIN account ON post. Account_id = account. Account_id WHERE post_id > neww ORDER BY post_date ASC LIMIT 10) AS T1 ORDER BY post_id DESC.

1 that's what I'd do – Alex Mar 1 '10 at 22:30 Wow, Notice the race condition that occurred here. (both posted Mar 1 at 22:13) While both answers are correct only one can get the "correct" answer. I find it interesting that Mark's answer names the sub-query T1 and then doesn't reference it.

– sholsinger Sep 24 '10 at 15:45.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.