Sort/order query result?

[gordonrp]

Hey guys, in my photo gallery it currently picks out the photos in order they were added to the table, top down. I want to read the photos by id number highest to lowest.

So I want the query to return the highest id entry first.

my current code is:

$result = mysql_query( "SELECT * FROM photos" );

I tried this:

$result = mysql_query( "SELECT * FROM photos ORDER BY id DSC" );

but no luck, can anyone point me in the right direction?

thanks
gp

[BooRadLey]

$result = mysql_query( "SELECT * FROM photos ORDER BY id DESC" );

or:

$result = mysql_query( "SELECT * FROM photos ORDER BY id ASC" );

Brad

[gordonrp]

Thanks Brad, Im such a fool.... DESC rather than DSC!

cheers,
gp