Re: script not working in php - Mailing list pgsql-general

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