Skip site navigation (1) Skip section navigation (2)

Re: What's wrong with this? (Pt II)

From: info(at)i-developit(dot)com
To: pgsql-novice(at)postgresql(dot)org
Cc: John Poltorak <jp(at)eyup(dot)org>
Subject: Re: What's wrong with this? (Pt II)
Date: 2001-01-22 09:40:34
Message-ID: 3A6C0012.7857F234@i-developit.com (view raw or flat)
Thread:
Lists: pgsql-novice
Don't forget too that when you do a pgsql_fetch_array,
the way your are doing it, it will only pull the last
item. You need to make that in a while loop, so that
it will retreive all the rows of data.

Example:

while($row = pgsql_fetch_array($result))
{
	echo $row["townName"];
}

This will display all the townName entries that were a part
of your query. (i.e., if there were 4 results returned, it would
display all 4 results, but only the column townName)


Hope this helps,
Andy Holman


GH wrote:
> 
> On Mon, Jan 22, 2001 at 01:31:16AM +0000, some SMTP stream spewed forth:
> *snip*
> > <?
> > $connectid = pg_connect("194.164.53.200", "5432", "postgres");
> 
> This syntax is deprecated. What version of PHP are you using?
> The more correct syntax would be
> pg_connect("host=194.164.53.200 port=5432 user=<user>"
>         ." password=<password> dbname=<database>");
> http://www.php.net/manual/function.pg-connect.php
> 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 63.147.13.10, user nobody, database postgres in
> /depot/home/grasshacker/public_html/pg_test.php on line 10
> ---
> 
> gh
> 
> *snip*
> 
> > Can anyone try running this snippet on their own system and show
> > me what happens?
>  Tried...did.
> >
> > 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.
> 
> >
> > --
> > John

In response to

Responses

pgsql-novice by date

Next:From: John PoltorakDate: 2001-01-22 10:04:52
Subject: Re: What's wrong with this? (Pt II)
Previous:From: GHDate: 2001-01-22 02:36:09
Subject: Re: What's wrong with this? (Pt II)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group