How to sort an associative array alphabetically in php?

Question

I am getting my array values from database. and it is just names of users. Iam printing them as it as they are retrieved , I want to print them Alphabetical order of their names (Ascending Order). How can I do this ?

foreach($common_follows as $row) // $common_follows contains the IDs of users
            {

        $names=$obj2->get_user_name($row); //this function gets the name from user ID

                    while   ($rows = mysql_fetch_assoc($names)) // For getting the name of the person being followed
                    {
                sort($rows['name']); //Not seems to sort
                        echo '<img src="https://graph.facebook.com/'.$rows['user_id'].'/picture?type=normal" width="65" height="20" id="fbthumb">';
                        echo $rows['name']."<br>";
                      $count_common++;
                    }
            }

That sort function does not seem to work , since at each loop iteration a single name is returned .

I am retrieving each name from its user_id. Sorting bu userid does not sort them alphabetically. How can I use that sort function ? — Faizan
– Faizan, Commented Jan 6, 2013 at 17:24
it is the code that retrieves all user IDs from database and saves them to $common_follows array. — Faizan
– Faizan, Commented Jan 6, 2013 at 18:36

abhi.gupta200297 · Accepted Answer · 2013-01-06 17:28:22Z

3

You can sort a PHP array by key using ksort. if you want to sort by value, use asort.

answered Jan 6, 2013 at 17:28

abhi.gupta200297

8916 silver badges12 bronze badges

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

Comments

diggersworld · Accepted Answer · 2013-01-06 17:28:27Z

1

If you wanted to move the sorting to your MySQL you could do it like so:

SELECT *
FROM users
ORDER BY name ASC

This is only an example you'll need to match your table/column names.

With your example code you could make $common_follows into a comma separated string i.e. 1,2,3... and pass that into the query rather than looping and making multiple MySQL queries. This would look like the following:

SELECT *
FROM users
WHERE id IN (1,2,3) // <-- comma separated string
ORDER BY name ASC

answered Jan 6, 2013 at 17:28

diggersworld

13.1k25 gold badges87 silver badges120 bronze badges

Comments

Rocks · Accepted Answer · 2013-01-06 17:34:36Z

0

<?php

 $fruits = array("lemon", "orange", "banana", "apple");
  sort($fruits);
 foreach ($fruits as $key => $val) {
echo "fruits[" . $key . "] = " . $val . "\n";
}

  ?>

answered Jan 6, 2013 at 17:34

Rocks

5111 gold badge6 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to sort an associative array alphabetically in php?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related