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