PHP多维数组排序

Question

Edit : I need it to do only in Array Sort, As i am using procedure and sending it into json,

Here is my Table Structure,

SQL Fiddle

I want to display as

1. alpha london
2. alpha newyork
3. beta delhi
4. beta sydney

I mean, the second coloumn (name) should be in Ascending Order and the third coloumn (place) should be in Descending Order.

How i want is

1. alpha london
2. alpha newyowk
3. beta delhi
4. beta sydney

The Name should be in Asc Order and then to the right, the Place should be in Desc Order

What i have tried so far is

How can i do this ??

<?php
include ('conn.php');
$sql="SELECT * FROM test";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
while($rows=mysql_fetch_array($result))
{
foreach($result as $k=>$v)
{
echo $k;

}
}
?>

It displays the result as Invalid argument supplied to for each. What is the mistake i am doing and how can achieve my output

Answer 1

So why don't you do an order in your query itself like

SELECT * FROM test order by name;