[PHP] Sort a an array?

[Allen May]

I want to sort a result set from a mySQL query (see code below).
I can't figure out how to properly sort the $result in the while loop.

I just want to alphabatize the search result.

Any suggestions how to do this?

Thanks

-Allen
[EMAIL PROTECTED] (remove _nospam to reply)

*************************************************************************

$query = "select * from $table";
$result = mysql_query($query);

print "<form name=\"JobDesc\" method=\"post\" action=\"jobdesc.php\">\n";

print "<select name=\"wilber\">\n";
while ($row = mysql_fetch_array($result)) :
   print "<option value=\"";
   print $row["Jobtitle"];
   print "\">";
   print $row["Jobtitle"];
   print "</option>\n";
endwhile;