Combining multiple arrays

[ducey]

Hi,

I am having problems trying to sort data that I retrieve from a database and then store in four arrays.

This is what I have so far:

$query = "select * from policyfiles where filename='$file'";
$returned = mysql_query($query, $connection);
$rows = mysql_num_rows($returned);

$array = mysql_fetch_array($returned);
$titleArray[$counter] = $array[1];
$reviewdateArray[$counter] = $array[2];
$statusArray[$counter] = $array[3];
$fileArray[$counter] = $array[0];

Is there a better way to store this info in preferably only one array? I did try a 4D array, but I got confused when trying to retrieve data from it!

Also, with the setup above, is there anyway I can sort all the arrays alphabetically, because if I did them one at a time, they would all lose their correct placings within the array.

Many thanks for any help,

Nathan

[The_Chancer]

You can sort alphabetically by using http://www.php.net/asort

[ducey]

Cheers for the suggestion The Chancer, but I'd like to know if there is a way to store four values in one array or otherwise, sort four arrays that each contain the data.

Each array is important in that:

• Each row of each array is one returned row from the database

*If i sort one array, the other arrays data is not correct in relation to the new sorted array

So what i'd like to know, if possible, are two things:

1. Sort four individual arrays whilst maintaining the correct values associated with each row.
2. Combine four bits of data into one array, similar to a 4D array and then how to retrieve the data from it.

Any help is much appreciated.

Nathan