Sorting

[Anon]

Hello,
I'm relatively new at PHP/MySql, I need to sort the results of a query a display it on the screen. The book I am using is somewhat lacking in 'Real World' examples. I have included the code below. Any Help is appreciated.....
<?
require("connect.php");
$result = mysql(jvstudios_com, "select * from contacts");
$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)
{
$num=mysql_result($result,$i,"RecNum");
$first=mysql_result($result,$i,"First");
$last=mysql_result($result,$i,"Last");
$em=mysql_result($result,$i,"Email");
$ph=mysql_result($result,$i,"BestNum");

$row = ($num ." " .$first ." " .$last ." " .$em ." ".$ph);
echo"<table width=\"100%\" border=\"1\"bordercolor=\"#006600\">

<tr>";
echo"<td width =\"20%\">&nbsp;<a href=\"getrecord.php?num=$num\">$first $last</a></td>";
echo"<td width =\"20%\">&nbsp;$ph</td>";
echo"<td width =\"40%\">&nbsp;<a href=\"mailto:$em\">$em</a></td>";
echo "</tr>
</table>";
}

?>

[junebug]

just add an order by to the end of your query and mysql will order the results by the field you specify:

select * from contacts order by firstname asc

that will return the query ordered by firstname in an ascending order

select * from contacts order by firstname desc

that will return the query ordered by firstname in a descending order

[Anon]

Thanks, works like a charm.