Re: sql output to a multidimensional array

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",   100,     20,     65,

55 ),

                                  array ( "CCC",    56,     21,      0,

90 )

                                );
I have tried and am unable so far to get this out of my database. Any suggestions? "SELECT count( publications.title) AS title_number, publications.year,

publications.affiliation=20 FROM publications GROUP BY affiliation, year ORDER BY year"; There is some "for loop" I am not getting, and am also not getting the = zero counts with the count(*).

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). You won't get zero counts for data that doesn't exist, you'll need to generate your series before hand: <?php for ($i = 2000; $i < 2006; $i++) { $data[$i] = 0; } ?> then later on override that value. -- Postgresql & php tutorials http://www.designmagick.com/