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