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
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.. |
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 |