Easy Order Question

[tet3828]

Can someone direct me to a reference that will show me where in this code do I drop the ORDER by command to alphabetize my drop down box?

 

 

 

$fields = mysql_list_fields("21support", "apps", $connection); 

$columns = mysql_num_fields($fields); 

echo "<form action=page_to_post_to.php method=POST><select name=Field>"; 

for ($i = 0; $i < $columns; $i++) { 

echo "<option value=$i>"; 

echo mysql_field_name($fields, $i); 

} 

echo "</select></form>"; 

?>

 

[redking]

I'm guessing you have an sql query.

 

somthing like

$sql = "SELECT * FROM `bar`
          WHERE `foo` = '1'";

change that to 

$sql = "SELECT * FROM `bar`
          WHERE `foo` = '1'"
          ORDER BY `column` ASC";

               

ASC goes from 1 to 10 A to Z

DESC goes from 10 to 1 Z to A

 

hope this helps

[onlyican]

It would be best to do something like this

 

$query = "SELECT 21support From Apps ORDER BY FieldName ASC

$result = mysql_query($query);

 

instead of using your mysql_list_fields