Postgre Prob
| From: | Nicolas Raitman | Date: | Sat, 11 Nov 2000 20:06:27 +0000 |
| Subject: | Postgre Prob | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4376@lists.php.net to get a copy of this message | ||
Hi to all. I have a table I created the following table in database called
clients doing the following:
create table people (name varchar(50), lastname varchar(50), phone
varchar(60), comment varchar(50));
the, with php I do the following
$con = pg_connect("dbname = clients");
$ret = pg_query($con, "Select * from people");
$row = 0;
while ( $data = pg_fetch_object ($ret, $row))
{
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>",
$data->name, $data->lastname, $data->phone, $data->comment);
$row++;
}
Ok... when I execute the script I get everything ok but also the following
warning:
unable to jump to row 8 on PostgreSQL result index 5 in line...
Of course, the number of the row depends on how many records I have on the
table. The thing is that it shows me ecxactly the same number of records in
tne table as the number of the row that it complains about jumping at...
what is it wrong?
Thanks a lot,
Nicolas