Re: PHP and PostgreSQL

Hi

I think You misunderstand the function You use. What was You expect to get
when You try to access to not exsisting row? When You are doing "while" it
will exit on ``false'' value - so when You access to not existing row the
function produce ``false'', but also PHP produce Error message if You dont
prevent it in php.ini or with "@" before function call. See that Yours
code will exit "while" loop when You $row counter will get 4. First $row
is set to 4 then "while" test the return value of function in $data. So
don't be suprised such error warning. You are try to gen not existing
object.

If mysql relevant function dont produce error warning in such situation
IMHO is something wrong with mysql access function in PHP rather than
postgreSQL access function. But ... let's don't start wars again ;)

BTW... IMHO it is not good practice to use errors as exit code for
loops. Feel free to disagree ;))))

regards
Robert

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