Multi-dimensional array sort help

[AngelGSD]

Hi, I want to sort my multi-dimensional array based on certain column. How do I do it?

$arr[$x][alpha]="testing 1";
$arr[$x][beta]="testing 2";

I want to sort the multi-dimensional array based on beta.

Thanks in advance

[Weedpacket]

[man]usort[/man] Example 2.

[AngelGSD]

I have tried the sorting based on your suggestion. But the result is wrong. Anymore ideas?

[tsinka]

Hi,

pos the complete code, so we can see what might be wrong 🙂

[AngelGSD]

Below is my code

<?php
session_start();

function cmp ($a,$b) {
return strcmp($a[0],$b[0]);}

$x=0;

$query ="select field1,field2,field3,field4 from mysqltable";
$result=mysql_query($query, $link);
while($myrow=mysql_fetch_row($result)) {
$arr[$x][0]=$myrow[0];
$arr[$x][1]=$myrow[1]; // I want to sort based on this column
$arr[$x][2]=$myrow[2];
$arr[$x][3]=$myrow[3];
$x++;}

usort($arr,"cmp");

echo "<table>";
for ($x=0;$x<count($arr);$x++) {
echo "<tr><td>".$arr[$x][2]."</td>";
echo "<td>".$arr[$x][1]."</td>";
echo "<td>".$arr[$x][3]."</td>";
echo "<td>".$arr[$x][4]."</td>";
echo "<td>".$arr[$x][0]."</td></tr>";
}

echo "</table>";
echo "</body></html>";

?>

[tsinka]

Hi,

in your sort function change $a[0],$b[0] to $a[1],$b[1]. You might want to use associative arrays to improve readability.

[AngelGSD]

Hi, still not working.... please tell me more about associative array...

[tsinka]

Hi,

more to come about associative array later it should work either. Try the following function:

function cmp ($a,$b) 
{ 
    $cmp = strcmp($a[1],$b[1]);
    return $cmp ? $cmp : -1;
} 

[AngelGSD]

Hi,

IT WORKS! 🙂 Thank you very much! 😃