Sort a an array?

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 umayxa3@donet_nospam.com (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;