[ LUGOS ] Postgres Trouble

[milan.gabor na uni-mb.si]

Hi!


Instalacija php in postregresa je sla BP.
Povezava do DB tudi.
Potem pa zacne postgres nekaj carati v tem smislu :

milan (milan): janez (janez): 
Warning: Unable to jump to row 2 on PostgresSQL result index 2 in
/home/httpd/html/php3/query.php3 on line 10

----------
Id: milan
Password: milan
----------
Id: janez
Password: janez

Warning:  Unable to jump to row 2 on PostgresSQL result index 2 in
/home/httpd/html/php3/query.php3 on line 21

----------

Source za ta query pa je tale : 

$qu = pg_exec ($conn, "SELECT * FROM users");
$row = 0; // postgres needs a row counter other dbs might not

while ($data = pg_fetch_object ($qu, $row)):
    echo $data->id." (";
    echo $data->password ."): ";
    $row++;
    endwhile; ?>

   <PRE><?
   $fields[] = Array ("id", "Id");
   $fields[] = Array ("password",  "Password");

   $row= 0; // postgres needs a row counter other dbs might not
   while ($data = pg_fetch_object ($qu, $row)):
echo "----------\n";
   reset ($fields);
   while (list (,$item) = each ($fields)):
   echo $item[1].": ".$data->$item[0]."\n";
   endwhile;
   $row++;
   endwhile;
   echo "----------\n"; ?>
   </PRE>    

Kaj bi bilo narobe ?

lp,
Milan