So i have been working a custom forum for my site and everything is pretty much done just not sure how to order the topic list right.
On your standard forum when viewing the list of topics new topics are on top and that is easy you can order by id for that but i am not sure how you bump any topic that gets a reply to the top of the list.
Here is my code for pulling the list of topics
[php]$query2 = mysql_query(“SELECT * FROM topics WHERE forumid = ‘mysql_real_escape_string($id)’ ORDER BY id DESC”);[/php]
here is my database structure
id
forumid
message
subject
username
date
lastreplydate
numreplies