Then you should put some debugging around the connection code.
|$pgconn = pg_connect("host=localhost port=5432 dbname=test user=test password=test")| or die("Problem with connection to PostgreSQL: ".pg_last_error());
So you can be sure that you are really connected. Also you can use pg_result_error()...
$result = pg_query_params($pgconn, $update, array($foo, $bar)); echo pg_result_error($result); or even pg_result_error_field(). Brandon Metcalf napsal(a):
b == bran...@geronimoalloys.com writes: b> I'm fairly new to PHP but have a great deal of Perl experience for b> what it's worth. I'm having a problem where if I try to use a b> parameterized query it fails but pg_last_error() returns nothing. For b> example, b> $result = pg_query_params($pgconn, $update, array($foo, $bar)); b> if (! $result) { b> fwrite($fp, "before"); b> fwrite($fp, pg_last_error()); b> fwrite($fp, "after"); b> } I should also mentioned with log_statement = 'all' in postgresql.conf, nothing is dumped to the logs. This tells me pg_query_params() isn't passing anything to the postgres server.
-- S pozdravem Daniel Tlach Freelance webdeveloper Email: m...@danaketh.com ICQ: 160914875 MSN: danak...@hotmail.com Jabber: danak...@jabbim.cz