quick easy sorting question

[mjdth]

My code is posted below. I'd like the for loop to go IN REVERSE, but I can't figure out how to do that. I tried for($i=$n;$i>0;$i--) but that obviously doesn't do the trick. Thanks for any help!

<?php
$r=mysql_query("SELECT * FROM `studioMetryV2SingleBought` WHERE 1;");
@$n=mysql_num_rows($r)+0;
if($n==0) {
	echo "No purchases!!";
}

for($i=0;$i<$n;$i++) {
	$line=mysql_fetch_array($r);
	echo "<TR class='normal'><TD>".$line['name']."</TD>
	<TD>".$line['email']."</TD>
	<TD>".$line['txnID']."</TD>
	<TD>".$line['sn']."</TD>
	<TD>".$line['type']."</TD>
	</TR>\n";
}
	echo "</table>\n";
?>

[TheDefender]

The trick would be to pull your array in the reversed order first...

Add an ORDER BY clause to your query that will order by a Unique ID Key field... Primary Key should do the trick if you are using an auto-incremented integer type field for that.

$r=mysql_query("SELECT * FROM studioMetryV2SingleBought WHERE 1 ORDER BY primary_key_field DESC");

Then just run your FOR loop like normal.