Re: problem with SUM and Postgres

Because pg_exec only executes the query and returns the resource that's associated with the returns. If you want to read the results, you should use pg_fetch_result(): $sql1 = "SELECT SUM(hostingcost) FROM $tablename WHERE webserver = '$webserver'"; $hosting_rs = pg_exec($connect, $sql1); $hosting_data = pg_fetch_row ($hosting_rs, 0); $hosting = $hosting_data[0]; Marco On Wed, 2002-10-09 at 19:29, webmaster wrote: > I can't figure out why the following code is not returning a column > total: > > $sql1 = "SELECT SUM(hostingcost) FROM $tablename WHERE webserver = > '$webserver'"; > $hosting = pg_exec($connect, $sql1); > echo $hosting; > > This returns: Resource ID #3 > > The only thing I can think of is that the hostingcost column's default > value is set to MONEY which is a postgres specific constraint. The > query works fine within psql on the server, but not with php. > > Thanks for any help. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >