display sql results in order with sequential variable

[bobocheez]

Hi,

I have a piece of code where, $n is a sequential number from 1-20, and $display is from the database with numbers 1-20, but in a random order.

How can the following code be edited so that $display will equal $n?

 

$n = 0;
while ($n < 20) {
$n++;

$query_d = "SELECT display FROM hits_d WHERE id='$n' ORDER BY display DESC";
$result_d = mysql_query($query_d) or die('Sorry, could not access the database');
$row_d=mysql_fetch_array($result_d, MYSQL_BOTH);
$display = $row_d['display'];

$ad = '$ad'."$n";
if ($display == $n) {$showad = $ad;}
echo "n: $n display: $display showad: $showad<br/>";
}