Re: Sort a an array?

Change $query = "select * from $table"; to $query = "select * from $table order by Jobtitle"; Assuming (from your code) you want them alphabatized by Jobtitle of course =P Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com ----- Original Message ----- From: Allen May <umayxa3@donet.com> To: <php-general@lists.php.net> Sent: Thursday, August 16, 2001 10:31 AM Subject: [PHP] 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;