Display results in number order

[Anon]

I have managed to narrow my number search down and display the results. What i want to do is display the results in number order. I know I am nearly there, but can someone please help. Here is my script that outputs the numbers.

---

<?
include("connect_info.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM price WHERE actual_price BETWEEN '$min_price' AND '$max_price' ORDER BY min_price DESC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$actual_price=mysql_result($result,$i,"actual_price");

?>

<P>Price <? echo"$actual_price";?><BR>

<?
++$i;
}

[tomhath]

When you say "number order", what number? If you want actual_price, then just change the ORDER BY

ORDER BY actual_price DESC

[Anon]

I have sorted the problem out. Thanks to you all for helping me out. I have been working hard on these databases, and I now have a set of scripts that update, delete and add records to a database.