Sorting a PHP 2D Array?

[random1]

I have a 2D array that consists of values returned from a database query (columns and rows).

 

I'd like to be able to sort the array according to a field name (column heading) and Ascending or Descensing.

 

I've had a look at: http://www.php.net/manual/en/function.array-multisort.php

 

and the code asort($records);

 

But they don't seem to do the job.

 

How can a 2D array be sorted this way?

[PHP_PhREEEk]

There isn't an array sort you can dream up that PHP can't handle, even if you need to create a custom user sort function. That being said, if you give us an example array you need to sort, we can have a go at it...

 

PhREEEk

[Daniel0]

Why not just use ORDER BY something (ASC|DESC) in the query?

[teng84]

Why not just use ORDER BY something (ASC|DESC) in the query?

 

yes if you mean array is the array that you get form DB upon fetching it will be very hard just use the orderby clause of your sql ..  although you can do that in php it will take number of codes to finish it and it not a good practice

[random1]

Okay cool, I thought I should do it in the SQL query

[Daniel0]

Okay cool, I thought I should do it in the SQL query

 

If you can you should.