script not working in php

On 06/10/2011 13:22, 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?

What does it say in the PHP log?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

Thanks....simple but important!

________________________________
Von: Rodrigo Gonzalez <rjgonzale@estrads.com.ar>
An: Robert Buckley <robertdbuckley@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