Cannot connect

[aidema]

I can't establish a connection to postgres from a browser. In my php script I have the following syntax...
//Connect to the database

$connection=pg_connect("IP#","port","database","username","password");

if (!$connection)
{
echo "Sorry, could not establish a connection";
exit;
}

It's not working and here is my error message...

Warning: pg_connect() unable to connect to PostgreSQL server: fe_sendauth: no password supplied in /usr/local/apache/htdocs/postgre/php/add_new_client.php on line 15
Sorry, could not establish a connection

Any ideas?

Thanks,

Andy

[_SuperString]

try agian with this connection string:

pg_connect ("host=hostname port=portnum dbname=databasename user=username password=databasepassword");

Change the host, port, dbname, user and password values.

[[deleted]]

You should connect with the following syntax:

$dbconn3 = pg_connect ("host=sheep port=5432 dbname=mary user=lamb password=foo");

[edit: doh! beaten to it]

[aidema]

That's exactly what I did and it worked great. I did a search on the pg_connect function on php's site and that's what they gave me too. Thanks everyone.

Andy