im not very good at this one mysql thingy: ORDER BY,

its too order topics in my forum by last post date, if anyone could tell me or give me a tutorial that would be great

also if anyone could,
i made a pagination thing by myself and i need to know how it shows just 3 numbers then ... like this:
<First 55 56 57 Last>

MySQL is very confusing cause I can't find a site that has the syntax of MYSQL and hot to use it..??.

sorta off topic there Chaos_Blader lol

Chaos Douglas known how to do this stuff.. If u need help with sumthing then make your own topic?

I am not sayin that I need help Im just sayin its hard to find good sites these days with already built stuuf on SQL besideds if you buy a bok it another story

ok so anyone know my question?

okay ORDER BY will be a part of your SQL statement and to choose what you want to order by you simply put the column name

so it would show up at the end as:

SELECT * FROM table ORDER BY date DESC;

date will be the column name or what ever the name for your time posted is and DESC means it will sort them in descending order, you can use ASC for Ascending order as well. Here's a page to a tutorial if I made no sense.

Here it be ORDER BY explained (http://www.webdevelopersnotes.com/tutorials/sql/online_mysql_tutorial_ordering_data.php3)

thanks