mysql - How to alphabetical sort php while loop variable?

Solution:

ORDER BY clause is used for any kind of sorting from database. So change your query in the loop like this:

$query = "SELECT `Name` from `list` WHERE `ID` = '$id' ORDER BY Name ASC  ";
Copy code

For more information: ORDER BY cluase

Let me know for further help.

Solution:

you can do it in single query, try this one..

$sql= mysql_query("Select DISTINCT Supervisor ID, Name from list ORDER BY Name ASC");

while($row = mysql_fetch_array($sql))
{   
     $uname = $row['1'];
     $Supervisor .="<OPTION VALUE=\"$uname\">".$uname.'</option>';

}
Copy code

Solution:

Use This:-

 $sql= mysql_query("Select DISTINCT(`Supervisor ID`) from `list`  ");

while($row = mysql_fetch_array($sql))
{   
     $id = $row['Supervisor ID'];
     $query = "SELECT `Name` from `list` WHERE `ID` = '$id'  ";
     $name = mysql_query($query);

     $username = mysql_fetch_array($name);
/* Sore name in to an new array */
     $uname[] = $username['0'];


}
Copy code

Sort your name Array Here Using

sort()
Copy code

Click Here For Demo of Sort function

 $user_names = sort($uname);
Copy code

Create Option valus like this

foreach($uname as $name) {
$Supervisor .="<OPTION VALUE=\"$name\">".$name.'</option>';

}
Copy code

Solution:

SELECT `Name` from `list` WHERE `ID` = '$id' order by `Name` ASC
Copy code

useorder by clause for ascending order and desc for descending order