On Mon, Jan 22, 2001 at 01:31:16AM +0000, some SMTP stream spewed forth:
> $connectid = pg_connect("184.108.40.206", "5432", "postgres");
This syntax is deprecated. What version of PHP are you using?
The more correct syntax would be
pg_connect("host=220.127.116.11 port=5432 user=<user>"
." password=<password> dbname=<database>");
The same is true for pg_pconnect().
> $query = "SELECT townName FROM towns";
> $result = pg_exec($connectid, $query);
> $row = pg_fetch_array($result,$row);
What is the value of $row that you are passing to pg_fetch_array?
(That should be the number of the row *in the resultset* that you
want to retrieve.)
In addition, I recieved a pg_hba.conf error when I attempted to test
this script, using what you sent. Can you clarify what
the username, password, and database are supposed to be?
Warning: Unable to connect to PostgreSQL server: No pg_hba.conf entry for
host 18.104.22.168, user nobody, database postgres in
/depot/home/grasshacker/public_html/pg_test.php on line 10
> Can anyone try running this snippet on their own system and show
> me what happens?
> It's coded to point at an host which _ought_ to be able to
> service a query.
It is not able to, at least, not in the context of this test.
In response to
pgsql-novice by date
|Next:||From: info||Date: 2001-01-22 09:40:34|
|Subject: Re: What's wrong with this? (Pt II)|
|Previous:||From: John Poltorak||Date: 2001-01-22 01:31:16|
|Subject: What's wrong with this? (Pt II)|