rsort mysql query

[fukumdaryl]

I''m new to the rsort command. How could I rsort this by image id? Any Ideas would be greatly appreciated.

$result = mysql_query("SELECT * FROM nuke_Submit_Art WHERE category = 'painting'");
if ($result){
	if (mysql_num_rows($result) > 0){
		while ($row = mysql_fetch_assoc($result)){
			echo "<td>{$row['imageID']}</td></tr>\n";
			echo "<tr><td><img src=\"{$row['thumbPath']}\"></td>\n";
		}
	}	
}

[thorpe]

you are better off to let mysql sort the data before you get it.

SELECT * FROM nuke_Submit_Art WHERE category = 'painting' ORDER BY imageid DESC

[fukumdaryl]

thank you so much. a simple thing, but Ive been racking my brain on how to do it ass backwards. Sweet!