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

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