not corectly executed

[pdsmet]

could somebody please take a look at this line of code, and tell me why this is not correctly displayed in the page :

$rs = mysql_query("select * from news ORDER BY year DESC, monthNR DESC, day DESC");

it is descending by year, but not the second monthNR
Thank You,
Peter

[bpat1434]

Me thinks it should be:

SELECT * 
  FROM news
  ORDER BY year, monthNR, day DESC

~Brett