On Thursday 30 May 2002 11:30, Steve G wrote: Please do not reply to an existing post. Start a new one!
> I do not understand why PHP is trying to pull row 2!! I want to create an > array of data and construct a table from a query. The echo of $rows shows > 2 rows, so if I'm setting my variable to 0 and incrementing with each loop, > it doesn't make sense to me why it tries to pull row 2. It should stop at > row 1 because the next loop would make the variable 2 and the if says if > $ii is less than 2. The if statement only runs once. At the time it is run the statement is true (ie $ii < 2) ... > WHAT AM I MISSING!? > > I have a while loop written to pull data from a postgreSQL database. I > have 2 and only 2 rows of data in this table. Probably labeled within > PostgreSQL as '0' and '1'. The browser displays the error message along > with the proper table listed below it!! ... but inside your while loop you have $ii++, which results in ... > Warning: Unable to jump to row 2 on PostgreSQL result index 2 in > /var/www/html/steve/frontdoor.php on line 92 > sgaas Steve Gaas > mjohnson Matt Johnson Basically you're going about this the wrong way. Replace this: > <? > if ( $ii < $rows) { > while ($tabledata = pg_fetch_array($results, $ii)) { <--(LINE 92) > > $username = $tabledata["username"]; > $firstname = $tabledata["firstname"]; > $lastname = $tabledata["lastname"]; > echo "<TR>\n"; > echo "<td>$username</td>\n"; > echo "<td>$firstname</td>\n"; > echo "<td>$lastname</td>\n"; > echo "</tr>\n"; > $ii++; > } > > } > ?> with: /** Untested use with extreme caution **/ while ($tabledata = pg_fetch_array($results)) { $username = $tabledata["username"]; $firstname = $tabledata["firstname"]; $lastname = $tabledata["lastname"]; echo "<TR>\n"; echo "<td>$username</td>\n"; echo "<td>$firstname</td>\n"; echo "<td>$lastname</td>\n"; echo "</tr>\n"; } -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Occam's eraser: The philosophical principle that even the simplest solution is bound to have something wrong with it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php