sorting data in a multi-dim array

Anon

hi,
How could i sort data in a multi-dim array?

for example:

$data = array(
array("Job 3","House Party","Done"),
array("Job 1","Days End","Done"),
array("Job 5","Light Wave House","Done"),
array("Job 2","The Amazon","Not Done"),
array("Job 4","Fear","Not Done")
);

I want to sort that array via the first,second or third key (Job ID,Job
Title,Job Status)
basically what i need to end up doing is having a table where i can click on
the header colums and sort ascending/descending based on the heading i
clicked

very much like SQL's ORDER BY, which ive been using so far, but now ive come
into a situation where the data cant be fetched from a DB.

Thanks in advance

brainiac

I don't know much about arrays, most certainly not about multi dimensional, but I think the function you are looking for are this:
Array_multisort()

http://www.php.net/manual/en/function.array-multisort.php

Anon

Hi,

I read Brians response and for this problem multisorot is NOT what you want.

first and formost I think this could be a lot simpler if you took

array("Job 4","Fear","Not Done")

and made Job 4 just 4.. then turn THAT into the main key.

so the revised array constructor would look like this. wraped in a loop ; loping for the amount of times there were to be elements or Jobs ---- so:

for ($i=1; $i<=$num_jobs; $i++)
{
$job_num =
//wherever you get your Job data
//parse this for just the num

$arr_data[$job_num] =
array (
'title' = $job_title,
'status'= $job_staus
);
}

Once this is completed the sorting will be 10 times easier as the jobs can be sorted by ordering the array[keys]!

Then use a function to parse the rest:
ussing 2 (list,each) or foreach to scoop the contents onto the screen.

Well, that one just came to me. Not easy but I've done this sort of thing before building a message board and it was ussing CLASSES and order list! OUCH.. Like the one they use here.

Good luck - let me know,
COPE