ORDER BY not working!!!

[hypnotic_monkey]

$query="SELECT artist_id, genre, title, description, url, realName, memberName FROM mixes 
	LEFT JOIN members ON (ID_MEMBER = artist_id)";

                         $result=mysql_query($query);
                         $num = mysql_num_rows ($result);                         

                         while($row = mysql_fetch_array($result))
                        {
echo'';
                        }

WORKS FINE!!!! but when i change it to:

 

$query="SELECT artist_id, genre, title, description, url, realName, memberName FROM mixes ORDER BY mix_id DESC  
	LEFT JOIN members ON (ID_MEMBER = artist_id)";

                         $result=mysql_query($query);
                         $num = mysql_num_rows ($result);                         

                         while($row = mysql_fetch_array($result))
                        {
echo '';
                        }

 

I get this:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in...

 

its just that ORDER BY bit..... what have i done wrong?

[JD*]

I think ORDER BY has to be the last thing in the query, even with a join