Re: script not working in php

Thanks....simple but important!

________________________________
Von: Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar>
An: Robert Buckley <robertdbuckley(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)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