RE: [PHP-DB] sql output to a multidimensional array

2006-09-08 Thread K.A.Bouton
> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 9:52 PM > To: K.A.Bouton > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] sql output to a multidimensional array > > > K.A.Bouton wrote: > > I

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Mitch Miller
Yeah ... it ain't purdy, and it sure doesn't scale so you have to be careful where you use it. This is usually more of a presentation issue that I'd suggest be left up to the application doing the display of the data. As an example, I believe Microsoft Excel has a crosstab function that can

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Chris
Mitch Miller wrote: K.A.Bouton wrote: > I need the output of my sql to be a multidimensional array as follows. then Chris wrote: > You won't be able to get an sql query to return in that format (I know > what you're trying to do, I've used the same chart software). This is my MSSQL Server s

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Mitch Miller
K.A.Bouton wrote: > I need the output of my sql to be a multidimensional array as follows. then Chris wrote: > You won't be able to get an sql query to return in that format (I know > what you're trying to do, I've used the same chart software). This is my MSSQL Server solution, and yep, it out

Re: [PHP-DB] sql output to a multidimensional array

2006-09-07 Thread Chris
K.A.Bouton wrote: I need the output of my sql to be a multidimensional array as follows. chart [ 'chart_data' ] =3D array ( array ( "", "2001", "2002", "2003", "2004" ), array ( "AAA", 0, 10, 30, 63 ), array ( "BBB

[PHP-DB] sql output to a multidimensional array

2006-09-07 Thread K.A.Bouton
I need the output of my sql to be a multidimensional array as follows. chart [ 'chart_data' ] =3D array ( array ( "", "2001", "2002", "2003", "2004" ), array ( "AAA", 0, 10, 30, 63 ), array ( "BBB", 100, 20,