show relevant code around the query and attempt to loop thru resultset
bastien
From: Vignesh M P N <manivig@xxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: 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
