order by

[Anon]

hi, i've got a mysql database that i'm trying to get the info out of, i can do this and order it by date, however it selects the earliest date and then orders it like that, does anyone know how to set it so that it will order it the other way around, eg

2001-05-12
2001-04-12
2001-03-12

instead of..
2001-03-12
2001-04-12
2001-05-12

thanks Martin

[Anon]

order by date desc

[vandana]

use - order by date DESC

[Anon]

thanks for your help, work great, thanks again, Martin