| 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: | 20010122100452.D85@eyup.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
hurdle...
> 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:-
<HTML>
<HEAD>
<TITLE>pg_test</TITLE>
</HEAD>
<BODY>
<?
$connectid = pg_connect("194.164.53.200", "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
4.0.4pl1
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
--
John
| From | Date | Subject | |
|---|---|---|---|
| Next Message | info | 2001-01-22 12:03:30 | Re: What's wrong with this? (Pt II) |
| Previous Message | info | 2001-01-22 09:40:34 | Re: What's wrong with this? (Pt II) |