[PHP-DB] Sorting Multidimensional Array

[Keith Spiller]

Hi,

RE:  Sorting Multidimensional Array

I'm trying to sort a multidimensional array.  The data was taken from
a mysql query:

$myrow = mysql_fetch_row($result) {
  query[] = $myrow;
}

The purpose is to retrieve the table data and manually add a record,
then sort ASC by the startdate which is the forth field...

Something like:
  
$test = array_multisort($query, $key = '$query[4]');

Any help would be greatly appreciated.  Thanks,


Larentium

Re: [PHP-DB] Sorting Multidimensional Array

[Chris]

Keith Spiller wrote:

Hi,

RE:  Sorting Multidimensional Array

I'm trying to sort a multidimensional array.  The data was taken from
a mysql query:

$myrow = mysql_fetch_row($result) {
  query[] = $myrow;
}

The purpose is to retrieve the table data and manually add a record,
then sort ASC by the startdate which is the forth field...

Something like:
  
$test = array_multisort($query, $key = '$query[4]');


Any help would be greatly appreciated.  Thanks,


Is there a reason you want to do this in php rather than through the 
database itself?


Through the database, just add:

order by fieldname asc;

to the end of the query.

If you can't do it that way for whatever reason, post some sample data 
and what you want to get out of it.


--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Sorting Multidimensional Array

[Dave W]

You should be able to use usort()

On 10/31/06, Keith Spiller [EMAIL PROTECTED] wrote:


Hi,

RE:  Sorting Multidimensional Array

I'm trying to sort a multidimensional array.  The data was taken from
a mysql query:

$myrow = mysql_fetch_row($result) {
  query[] = $myrow;
}

The purpose is to retrieve the table data and manually add a record,
then sort ASC by the startdate which is the forth field...

Something like:

$test = array_multisort($query, $key = '$query[4]');

Any help would be greatly appreciated.  Thanks,


Larentium





--
Dave W