Problem with row pointer - pgsql

shans

Hi *,

I have a problem with the rowpointer to a resultset from PostgreSQL coming to PHP4.

The code is:

$row = 0;
while ($data = pg_fetch_object($login_result, $row))
{
$fname = $data->u_f_name;
$lname = $data->u_l_name;
$uid = $data->u_id;
$row++;
//if(pg_numrows($login_result) == $row) {break;}
}
and the following error occurs:
Warning: Unable to jump to row 1 on PostgreSQL result index 2 in ....

If i had replaced the comments at the end it worked - there is only one row in the resultset.

Do you have any idea why the while-loop does not work correctly?

thx in advance

Stefan

rrijnders

PHP raises an error because the pointer is invalid (there is no "1" offset if you only have 1 record, right?). You are expecting that to cause the while check to fail. It will, but the index error is raised first.

Change

while ($data = pg_fetch_object($login_result, $row))

while ($data = @pg_fetch_object($login_result, $row))

The @ will mute the index error and the while check will fail just as you expect it to.

-- Rich