Problem with pg_fetch_array

--Boundary_(ID_O2u7Usw/v8ikU37AUy8iBw)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

Hi



I am trying to display the rows from a database table in a grid.



I retrieved the results using pg_query() with a Select command. pg_query()
returns true.



But when I pass the results $rows to pg_fetch_array(), it returns false. I
even tried displaying the error, if any, using:



pg_fetch_array($rows) or die('fetch array failed: ' . pg_last_error());



I also tried pg_result_error(), but both didn't display error.



It just displays "fetch array failed: ", but it doesn't display any error.



When the pg_query() returns a result, I wonder why pg_fetch_array() is not
able to iterate through the rows.



I am new to this PHP database stuff, please help me in this.



Thanks

Vignesh.


--Boundary_(ID_O2u7Usw/v8ikU37AUy8iBw)--

RE: Problem with pg_fetch_array

show relevant code around the query and attempt to loop thru resultset

bastien

>From: Vignesh M P N
>To: php-db@lists.php.net
>Subject: [PHP-DB] Problem with pg_fetch_array
>Date: Mon, 23 Oct 2006 15:12:25 -0500
>
>Hi
>
>
>
>I am trying to display the rows from a database table in a grid.
>
>
>
>I retrieved the results using pg_query() with a Select command. pg_query()
>returns true.
>
>
>
>But when I pass the results $rows to pg_fetch_array(), it returns false. I
>even tried displaying the error, if any, using:
>
>
>
>pg_fetch_array($rows) or die('fetch array failed: ' . pg_last_error());
>
>
>
>I also tried pg_result_error(), but both didn't display error.
>
>
>
>It just displays "fetch array failed: ", but it doesn't display any error.
>
>
>
>When the pg_query() returns a result, I wonder why pg_fetch_array() is not
>able to iterate through the rows.
>
>
>
>I am new to this PHP database stuff, please help me in this.
>
>
>
>Thanks
>
>Vignesh.
>

____________________________________________________________ _____
Ready for the world's first international mobile film festival celebrating
the creative potential of today's youth? Check out Mobile Jam Fest for your
a chance to WIN $10,000! www.mobilejamfest.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Problem with pg_fetch_array

Vignesh M P N wrote:
> Hi
>
>
>
> I am trying to display the rows from a database table in a grid.
>
>
>
> I retrieved the results using pg_query() with a Select command. pg_query()
> returns true.
>
>
>
> But when I pass the results $rows to pg_fetch_array(), it returns false. I
> even tried displaying the error, if any, using:

You return $result to pg_fetch_array not $rows.

$query = "SELECT version()";
$result = pg_query($query);
while($row = pg_fetch_array($result)) {
print_r($row);
}

A shameless plug but: http://www.designmagick.com/article/10/

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php