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

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

From: John Poltorak <jp(at)eyup(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: What's wrong with this? (Pt II)
Date: 2001-01-22 10:04:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Mon, Jan 22, 2001 at 04:40:34AM -0500, info(at)i-developit(dot)com wrote:
> 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.

Yes, I am aware of that, but pulling any item appears to be proving a

> 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)

It appears that there is something fundamentally wrong.

Here's the full script:-



$connectid = pg_connect("", "5432", "postgres");

$query = "SELECT townName FROM towns";

$result = pg_exec($connectid, $query);

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


This is the response:-

Fatal error: Call to undefined function: pgsql_fetch_array() in test.php
on line 17

Line 17 => while($row = pgsql_fetch_array($result))

c:\>php  -v

Since this appears to be a PHP problem rather than anything specific to
Postges, I guess I should pursuit it elsewhwere. Is there anything like
a PHP-Novices mailing list anywhere?

> Hope this helps,
> Andy Holman


In response to


pgsql-novice by date

Next:From: infoDate: 2001-01-22 12:03:30
Subject: Re: What's wrong with this? (Pt II)
Previous:From: infoDate: 2001-01-22 09:40:34
Subject: Re: What's wrong with this? (Pt II)

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