mysql php random results sort by name

Question

I need to order by the name from the random results. My sql command:

SELECT * FROM oc_manufacturer ORDER BY RAND() ASC LIMIT 0,50

And it returns thhis array:

   [0] => Array
        (
            [manufacturer_id] => 16
            [name] => Azzaro
        )

    [1] => Array
        (
            [manufacturer_id] => 71
            [name] => Sony
        )

    [2] => Array
        (
            [manufacturer_id] => 104
            [name] => Casio
        )

    [3] => Array
        (
            [manufacturer_id] => 30
            [name] => Jeepers Peepers
        )

But i want to return first Azzaro, then Casio, then Jeepers Peepers, and Sony. I need to sort results by name from RAMDOM results. I tried sort arrays and some mysql commands but it is not worked.

You can use php's array sorting functions, or just wrap your query with another. E.g.: SELECT * FROM (SELECT * FROM oc_manufacturer ORDER BY RAND() LIMIT 50)x ORDER BY name; — Strawberry
– Strawberry, Commented Jun 5, 2014 at 10:25
I tried array sorting ksort krsort asort arsort but I can't get good result — user3710676
– user3710676, Commented Jun 5, 2014 at 10:25

Eloims · Accepted Answer · 2014-06-05 10:39:44Z

2

You can either

make a subquery (see Strawberry comment)

SELECT * FROM (SELECT * FROM oc_manufacturer ORDER BY RAND() LIMIT 50)x ORDER BY name;

sort the array in PHP

$array = ....; // make query
usort($array, function($item1, item2) {
    return strcmp($item1['name'], $item2['name']);
});

answered Jun 5, 2014 at 10:39

Eloims

5,2644 gold badges28 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

mysql php random results sort by name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related