RE: [PHP] Sort a an array?

Instead of trying to sort the result AFTER it returns from the query, you could use an ORDER BY clause in your query to sort the results prior to trying to output it? You could change your query to something like: "SELECT * FROM tablename ORDER BY fieldname" HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 smasiello@synacor.com -----Original Message----- From: Allen May [mailto:umayxa3@donet.com] Sent: Thursday, August 16, 2001 11:32 AM To: php-general@lists.php.net 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;