Array sorting

[Scott_J]

I have an array that has three 'fields'

[key][cat_id][cat_name]

where cat_id and cat_name are fields from a database.

How do I sort the array by cat_name?

I can only output it by key at the minute.

Thanks

[ligraci]

Why don't you try with two arrays (one for ID, the other for name) then sort them with array_multisort function?

[Scott_J]

Would that keep the relationship between the id and the name?

[ligraci]

Sure.
Do this
$ID=array(1,2,3);
$name=array(d,a,b);
array_multisort ($ID, $name, SORT_ASC);

$ID will be (2,3,1)
$name will be (a,b,d)

Hope it helps.

[Scott_J]

I have my data in each array but they aren't being sorted. This is the code I have used to get each part in each array...

$query = "SELECT cat_id, cat_name FROM categories WHERE parent = '$id'";

//run the query on the database
$result = $this->query($query);
$count = 0;

while ($row = mysql_fetch_array($result))
{

$idarray[$count]["cat_id"] = $row["cat_id"];
$namearray[$count]["cat_name"] = $row["cat_name"];
$count++;

}

So I have one array called idarray, with just the cat_id's in and then the other array with the names. When I use the multisort function on the arrays nothing happens.

Thanks