Re: Database connection

Hi Tom:

Thanks for the help.

Best regards,

Jill Jensen, MCP
Operations Manager


jill.jensen@aisn.net

AIS Network
Internet Services Worldwide
http://www.aisn.net

Office:  847. 202. 1400   x 27
Fax:      847-202-4460
Cell:     847. 530. 7845


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, January 29, 2003 1:02 AM
To: jill.jensen@aisn.net
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Database connection


"Jill Jensen" <jill.jensen@aisn.net> writes:
> $host = "localhost";
> $user = "srproject";
> $pass = "56364563";
> $db = "srproject";

> //open a connection to the database server
> $connection = pg_connect ("host=$local host dbname=$srproject
> user=$srproject password=$56364563");

This is surely wrong.

> $connection = pg_connect ("host=$host dbname=$dbuser=$user
password=$pass");

This looks reasonable except you need another space:

$connection = pg_connect ("host=$host dbname=$db user=$user
password=$pass");

            regards, tom lane