[SOLVED] ORDER BY datetime Problems
Posted: Sat Apr 02, 2005 12:42 pm
This code is part of a message board I'm making. This query gets the topic and the replies made to it, but it seems like the replies are ordered randomly, even though I've used ORDER BY `posted`
It's a lot of code, and I think this is the only part that would really affect it.
EDIT: Sorry for wasting your time. I made a dumb mistake, it should be ordered ASCENDING. It works great now.
Code: Select all
$query = mysql_query("SELECT * FROM forum WHERE replied_to='{$_REQUEST['post']}' ORDER BY `posted` DESC");EDIT: Sorry for wasting your time. I made a dumb mistake, it should be ordered ASCENDING. It works great now.