Search Postgresql Archives

Re: problem with round() in php script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Im not quite sure what you are referring to....this is my php code. The connection is included, but not in the sql query!

<?

$connection=pg_connect("host=*** port=*** dbname=zgb user=*** password=***");

$result = pg_query('
SELECT name,round(ges_kw,0)
FROM energie.tennet_auswertung_2010
 ');


$rows = array();
while($r = pg_fetch_assoc($result)) {
    $rows[] = $r;
}
print json_encode(array_values(pg_fetch_all($result)));


?>



Von: Raymond O'Donnell <rod@xxxxxx>
An: Robert Buckley <robertdbuckley@xxxxxxxxx>
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Gesendet: 10:42 Donnerstag, 6.Oktober 2011
Betreff: Re: problem with round() in php script

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
rod@xxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux