How to alphabetical sort php while loop variable?

Question

i am selecting an id from a table and then by id getting name of all members by their ids. Now the problem is that , how to sort name ($uname) alphabetically? It could be simple but i am stuck ..thanks for the help!! Code below -

$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);

     $uname = $username['0'];


     $Supervisor .="<OPTION VALUE=\"$uname\">".$uname.'</option>';

}

Anand Solanki · Accepted Answer · 2015-03-11 05:44:05Z

3

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  ";

For more information: ORDER BY cluase

Let me know for further help.

answered Mar 11, 2015 at 5:44

Anand Solanki

3,4254 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

gaurav k Over a year ago

Thanks but i tried this already but it was not working. Is there any way that we can sort $uname variable?

Anand Solanki Over a year ago

Make one change in database & query will work. Go to database table column 'Name' and set it's 'Collation' as 'utf8_general_ci'. I think after this query has to work.

Sarath Kumar · Accepted Answer · 2015-03-11 05:47:46Z

1

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>';

}

answered Mar 11, 2015 at 5:47

Sarath Kumar

2,3531 gold badge14 silver badges26 bronze badges

1 Comment

gaurav k Over a year ago

No actually, it will list all the names but i need only names corresponding to Supervisor Id.

Harpartap Singh Permar · Accepted Answer · 2015-03-11 05:52:54Z

0

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'];


}

Sort your name Array Here Using

sort()

Click Here For Demo of Sort function

 $user_names = sort($uname);

Create Option valus like this

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

}

edited Mar 11, 2015 at 5:52

answered Mar 11, 2015 at 5:50

Harpartap Singh Permar

2892 silver badges13 bronze badges

3 Comments

Harpartap Singh Permar Over a year ago

Please Click True if answer is right. and also like the answer.

gaurav k Over a year ago

i can not vote up ur answer because i am new here and don't have reputation.

Harpartap Singh Permar Over a year ago

You can mark this Question as right. By just click True for this you don't need any reputition.

Anand Solanki · Accepted Answer · 2015-03-11 05:56:14Z

0

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

use order by clause for ascending order and desc for descending order

edited Mar 11, 2015 at 5:56

Anand Solanki

3,4254 gold badges19 silver badges27 bronze badges

answered Mar 11, 2015 at 5:53

siddhesh

5631 gold badge9 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to alphabetical sort php while loop variable?

4 Answers 4

2 Comments

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related