Sort dynamic select list fuction Alphabetically

[portabletelly]

Im trying to sort this dynamic select list alphabetically, but dont really have a clue how to do it? 

 

function createList(){
include("connect.php");
include("selectdb.php");

$query = "SELECT name FROM customer_tb";
$result = mysql_query($query, $link);
   if(mysql_num_rows($result))
   		{
       // we have at least one user, so show all users as options in select form
       while($row = mysql_fetch_row($result))
       {
          print("<option value=\"$row[0]\">$row[0]</option>");
        $test="while";
        }
     }
     else {
      $test="else";
      print("<option value=\"\">No users created yet</option>");
     }

}

[mlavwilson]

$query = "SELECT name FROM customer_tb";

 

$query = "SELECT name FROM customer_tb ORDER BY name";

[portabletelly]

Wow that was so easy. LOL i was expecting that task to be quite hard.

 

Thanx