On 06/10/2011 08:59, Robert Buckley wrote:
> hi,
>
> In pgadmin3 this query works ok.
>
> SELECT name,round(ges_kw,0)
> FROM energie.tennet_auswertung_2010;
>
> but in php 5.3.2 the result is 0 for all rows
>
> $result = pg_query('
> SELECT name,round(ges_kw,0)
> FROM energie.tennet_auswertung_2010
> ');
The first parameter in pg_query() is supposed to be the connection
returned by pg_connect() - the docs say that it can be omitted, but
that's not recommended. Have you tried it with the connection included?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general