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 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
[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;
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
