Sorting a list, greatest to lowest?

[rob]

I'm making this call

$sql_result = @mysql_query("SELECT * FROM blah WHERE type = '$something' AND my_goods = 'Yep' ORDER BY id",

What do i need to add to this command to have it list by id #, with the greatest id # at the top (greatest or most recent to lowest oldest)?

[jane]

You could use ...order by id (desending). or without the (). try it.

[DigitalExpl0it]

$sql_result = @mysql_query("SELECT * FROM blah WHERE type = '$something' AND my_goods = 'Yep' ORDER BY id ASC");

merry christmas

[rob]

ASC kept them in the same order, so I tried changing the ASC to DSC to see what would happen and all my link disappeared. So, is there a different code for descending order since I want to be listed in order from greatest to lowest, like this:

id=5
id=4
id=3
id=2
id=1

Thanks!

[rob]

I found the solution to the problem...

Use DESC instead of DSC or (descending)....

Thanks for the help though!