Thanks....simple but important!
________________________________ Von: Rodrigo Gonzalez <rjgonz...@estrads.com.ar> An: Robert Buckley <robertdbuck...@yahoo.com> Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Gesendet: 14:39 Donnerstag, 6.Oktober 2011 Betreff: Re: [GENERAL] script not working in php On 10/06/2011 09:22 AM, Robert Buckley wrote: Hi, > > >this works ok in pgadmin3 > > >select name[i], kw[i] >from ( select generate_series(1,6) as i, > array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', >'Wind','GESAMT'] as name, > array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, >kw] as kw > from energie.tennet_auswertung_pivot_energie ) z >; > > >but in the php script I get error 500? > > > > >$result = pg_query($connection,' >select name[i], kw[i] >from ( select generate_series(1,6) as i, > array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', >'Wind','GESAMT'] as name, > array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, >kw] as kw > from energie.tennet_auswertung_pivot_energie ) z >; >'); > You have single quotes inside the query and the complete string is defined with single quotes too.....use double quotes to define the string Rodrigo
