Order History Sort

My order history is putting the orders in what appears (I'm sure it's not) to be a random order (#61, 62, 51). I would like to sort the order history descending so the most recent order is always first (ORDER BY OrderID DESC). With everything that's going on I'm not sure how to accomplish this.

currently i have this in my record set query...

SELECT OrderID, OrderShipName, OrderAmount, OrderCountry, OrderShipping, OrderEmail, OrderDate, OrderShipped, OrderTrackingNumber
FROM orders
WHERE OrderUserID = WADAUser_ID

I have 2 variables: WADAUser, type N/A, default value -1 $_SESSION['User_ID']
and WADAUser_ID, type interter, default value -1 and no runtime value.

Can you help?

add the order by clause after the where clause:

SELECT OrderID, OrderShipName, OrderAmount, OrderCountry, OrderShipping, OrderEmail, OrderDate, OrderShipped, OrderTrackingNumber
FROM orders
WHERE OrderUserID = WADAUser_ID
ORDER BY OrderID DESC

Well, that's exactly what I thought, but when I tried to do it in DW record set query it kept giving me errors with the variables. I found the code on the page and added it there and all works great. You are the best!

mysql_select_db($database_users, $users);
$query_WADAorders = sprintf("SELECT OrderID, OrderShipName, OrderAmount, OrderCountry, OrderShipping, OrderEmail, OrderDate, OrderShipped, OrderTrackingNumber FROM orders WHERE OrderUserID = %s ORDER BY OrderID DESC", GetSQLValueString($WADAUser_ID_WADAorders, "int"));
$query_limit_WADAorders = sprintf("%s LIMIT %d, %d", $query_WADAorders, $startRow_WADAorders, $maxRows_WADAorders);
$WADAorders = mysql_query($query_limit_WADAorders, $users) or die(mysql_error());
$row_WADAorders = mysql_fetch_assoc($WADAorders);