From: | Robert Buckley <robertdbuckley(at)yahoo(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | script not working in php |
Date: | 2011-10-06 12:22:12 |
Message-ID: | 1317903732.76077.YahooMailNeo@web24108.mail.ird.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
;
');
$rows = array();
while($r = pg_fetch_assoc($result)) {
$rows[] = $r;
}
print json_encode(array_values(pg_fetch_all($result)));
can anyone explain whythis is happening?
thanks,
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2011-10-06 12:26:41 | Re: script not working in php |
Previous Message | Raymond O'Donnell | 2011-10-06 12:18:42 | Re: Restoring 2 Tables From All Databases Backup |