[Question] Order by date

[Mike_Wiseman]

Hello.

I am trying to get my tutorial system to echo the tutorials in the order of Earliest to Latest. I have searched pixel2life but i do not know excactly what to search so i didnt have any luck finding any results.

Is it possible you guys could either referr me to a site or even help me out yourself?

Thanks
Mike_Wiseman

[EDIT]

I have figured out how to do it:

$query = mysql_query("SELECT * FROM table order by date DESC");

If anyone else is having the same problem, that code works for me.

 

[Kate]

Just one remark by the way: be careful when naming table fields, not to use reserved keywords. I'm not sure 'date' is a reserved keyword in mysql but it could be with other database software. This may cause problems when executing queries.