Displaying in alphabetical order

[zzz]

Is there a predefined functions that would allow automatically return results in alphabetical order.

Currently I draw list from my db and put in in a drop-down menu, but it's all over the place since the results come in the order they were entered into the db:

<?php
result = mysql_query("SELECT * FROM my_table",$db);
echo "<select name=\"value\">";
while ($myrow = mysql_fetch_row($result)) {
print "<option value=\"". $myrow[4] ."\">". $myrow[4] ."</option>\n";
}
?>

[mmilano]

you can set the order in your mysql query. lets say you have a field in mysql named "last_name"

just make your query look like this:

<?
$result=mysql_query("select * from my_table order by last_name");
?>

that will return results in alphabetical ascending order.

hope this helps !

[zzz]

Yep! You nailed it!