PHP and PostgreSQL

From: Uro Gruber <uros(at)sir-mag(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PHP and PostgreSQL
Date: 2001-01-05 22:17:29
Message-ID: 631076786.20010105231729@sir-mag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-php

Hi!

I have some questions about coding in php with postgre.

Here is my code

$qu = pg_exec ($db_conn, "SELECT * FROM clients ORDER BY username");
$row = 0; // postgres needs a row counter other dbs might not
while ($data = @pg_fetch_object ($qu, $row)) {
echo $data->username." (";
echo $data->password ."): ";
echo $data->client_id."<BR>";
$row++;
}

When i execute this i get 3 records (in DB is also 3 records), if i
delete @ before pg_fetch_object i get an error:

"Unable to jump to row 3 on PostgreSQL result index 4"

I understand what's wrong and i know why is that @.

What i do want to know is, if there is something wrong with this
function or am i doing something wrong. I don't like that kind of
errors. How can i stop before the end.

In mysql there was no need to count rows.

Thanks
--
Uros

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lance Taylor 2001-01-05 22:26:13 Re: pg_dump return status..
Previous Message Nathan Myers 2001-01-05 22:17:09 Re: pg_dump return status..

Browse pgsql-php by date

  From Date Subject
Next Message gravity 2001-01-06 01:15:28 Re: PHP and PostgreSQL
Previous Message Partyka Robert 2001-01-05 19:16:05 Re: Autologin problem