Order results in SQL query
 

Is there a way to ORDER BY 2 different parameters at one go ?

Kinda of like

[sql]
ORDER BY date desc AND postcounts desc
[/sql]

?
Not sure if this makes sense :D

[sql]ORDER BY date DESC, postcounts DESC[/sql]That should do the trick for you.. :)

Thanks OK ! :D

If I'm not mistaken you can even do this:
[sql]ORDER BY date, postcounts DESC[/sql]

By the way, hopefully you're not using date as a column in your table :surprised:, that could cause problems unless you use the ` around the column name like this: `date`. I've just found it easier to not use those keywords.