Array Code Help

gray1st

Hi... I'm new here, and i'm seeking a little help with arrays.

In short... for whatever reason, i'm trying to extract data from 4 Access databases (Don't ask!!), with the same table in each to collate the value stored in the same field of each database, and add them together to get an overall value (numeric)

So I can extract all of the required data, and print it on screen, but I need to be able to sort the data by the Overall value. Having scoured a number of ideas, I think I'm left with putting the data into an array, and using a php sort function to sort the data in ascending order before printing on screen.

However, Arrays in PHP have simply confused me. I want to take 5 fields from each database...

HELP!

sneakyimp

If you are extracting data from an access database, perhaps you could structure your SQL to sort it when you query the access DB? You haven't told us how you are doing that so I'm not really sure what you're up to.

Array sorting in php is also possible as long as its a reasonable amount of data. The basic idea is that queries that return multiple records from a db usually let you iterate through the query results and each record is returned as either a numeric or associative array.

If you want to sort all the records, then you should put them all in a big array -- meaning that you'll have an array of arrays -- and then you can use something like [man]usort[/man] to sort the records in whatever order you like by looking at the values in each record.