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

----- Original Message ----- 
From: Allen May <[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?


[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";

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to