how to sort database records stored in array

Question

i have stored the records from database in a array. Now i want to sort the array based on the price index and than print the result according.

Can any one help me with this?

Code i tried ..

<?php
include('db.php');

$query = mysql_query("SELECT * FROM user");

$array = array();

while($row = mysql_fetch_assoc($query))
{
  $array[] = $row;
  $price[]=$row['price'];
}

echo "<pre>";
print_r($array);

Output..

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => abc
            [email] => abc@gmail.com
            [contact] => 27488887
            [price] => 12AED
        )

    [1] => Array
        (
            [id] => 2
            [name] => siddharth
            [email] => dgsfgsjkf@gmail.cm
            [contact] => 7878787
            [price] => 10AED
        )

    [2] => Array
        (
            [id] => 3
            [name] => abc
            [email] => def@gmail.com
            [contact] => 4554545
            [price] => 2AED
        )

    [3] => Array
        (
            [id] => 4
            [name] => xyz
            [email] => test@gmail.com
            [contact] => 878778
            [price] => 1AED
        )

    [4] => Array
        (
            [id] => 5
            [name] => dandas
            [email] => sdskagdsa
            [contact] => 24221
            [price] => 200AED
        )

    [5] => Array
        (
            [id] => 6
            [name] => ass
            [email] => asas
            [contact] => 78787
            [price] => 3AED
        )

)

Now i want to sort the array obtained as output by price and then display the records..

You can do this with mysql query : mysql_query("SELECT * FROM user ORDER BY price DESC"); — vural, Feb 03 '16 at 09:33
@vural The value of `price` looks crazy, I don't think normal sort will work. — Praveen Kumar Purushothaman, Feb 03 '16 at 09:34
i dont want to sort it with mysql order by as i have alphanumeric value for price — rinku simlai, Feb 03 '16 at 09:35
@Praveen Kumar: AED = Arab Emirates Dirham. But I agree: it looks crazy. — hherger, Feb 03 '16 at 09:36
no it can be sorted using standard sorting asort...check this:http://php.net/manual/en/function.natsort.php — rinku simlai, Feb 03 '16 at 09:37
change you mysql query like this "SELECT * FROM user order by price asc" this is assenting order -descending order like asc to desc — Vadivel S, Feb 03 '16 at 09:59

how to sort database records stored in array

0 Answers0