ordering a drop-down menu list

[sfields]

I am building a form that has a list/menu populating from the database. I'm using Dreamweaver to help code (which I know adds a mess), but I can usually edit it to do what I want.

this is what it has:
<option value="<?php echo $row_rsPhysician['specialtyID']?>"<?php if (!(strcmp($row_rsPhysician['specialtyID'], $row_rsPhysician['specialtyID']))) {echo "SELECTED";} ?>><?php echo $row_rsPhysician['specialtyName']?></option>
<?php
} while ($row_rsPhysician = mysql_fetch_assoc($rsPhysician));
$rows = mysql_num_rows($rsPhysician);
if($rows > 0) {
mysql_data_seek($rsPhysician, 0);
$row_rsPhysician = mysql_fetch_assoc($rsPhysician);
}
?>

although if you have any generic code, I can play with it to get it to alphabetize my list. (the list is specialtyName and specialtyID is going into the database. Thanks!

[krotkruton]

I stopped using dreamweaver for basically everything that has to do with php after a couple weeks of playing with it for the same reason you are having that problem.

The best way that I know to solve your problem is to order the database query. If your query is ordered, then all you have to do is go through the list with a while loop.

So this isn't exactly what you are looking for because this creates a table, so you just need to change this to create each entry in a form

$query_popular = "SELECT * FROM `barlist` WHERE `city` = '$city' ORDER BY `users`";
$popular = mysql_query($query_popular, $connBarHopper) or die(mysql_error());
$row_popular = mysql_fetch_assoc($popular);

<? do { ?>
	<tr>
	<td> <a href="bar_info.php?barid=<? echo $row_popular['id']; ?>">
		<? echo $row_popular['bar_name']; ?></a></td>
	<td> <a href="test_bar_search_results.php?query=<? echo $row_popular["city"]; ?>">
		<? echo $row_popular["city"]; ?> </a></td>
	<td> <a href="test_bar_search_results.php?query=<? echo $row_popular["state"]; ?>">
		<? echo $row_popular["state"]; ?> </a></td>
	<td> <a href="test_bar_search_results.php?query=<? echo $row_popular["zip"]; ?>">
		<? echo $row_popular["zip"]; ?> </a></td>
	<td> <a href="bar_users_list.php?query=<? echo $row_popular["id"]; ?>">
		<? echo $row_popular["users"]; ?> </a></td>
        </tr>
<? }
	while ($row_popular = mysql_fetch_assoc($popular)) ;
?>

That's basically how it works... to see an unordered example of form from a database that follows the same format:

				  <select name="state">
				  <option value=""> </option>
                	<?php 
						do {  

						?>
                  <option value="<?php echo $row_states['state']?>" >
				  	<?php echo $row_states['state']?></option>
                	<?php
						} while ($row_states = mysql_fetch_assoc($states));
						?>
              	  </select>

With those two, you should be able to figure out the rest, but let me know if ya can't