From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | "sheila bel" <sheilabel(at)hotmail(dot)com>, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] PHP3 and PostgreSQL |
Date: | 2000-02-20 21:08:42 |
Message-ID: | 4.2.0.58.20000220170535.00b21400@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try something like:
$NumRows = pg_NumRows($Result);
for ($CurRow =0; $CurRow < $NumRows; $CurRow++) {
$row = pg_Fetch_Object($Result, $CurRow);
....
}
I've never used Fetch_Object, but I know that this works with
Fetch_Array. Also, if you consult the pg_Fetch_Object item in the quick
reference on http://www.php.net/ it will probably have a code example.
At 04:29 PM 2/20/00, sheila bel wrote:
>SORRY, WRONG SUBJECT IN PREVIOUS MESSAGE.
>
>Hi all,
>
>I'm trying to do the equivalent of the following command of
>mysql (inside PHP3 code) in postgreSQL.
>
>while (($row = mysql_fetch_object($result))) .....
>
>I know there is the pg_fetch_object($result, ?) but I don't
>know what to use for ?. I tried 0 and it does an exhaustive
>search. I tried using something like $num
>
>$num=0
>while (($row = mysql_fetch_object($result,$num))) ...
>
>$num++;
>
>this is the error message I get :
>
>Warning: Unable to jump to row 1 on PostgresSQL result index 2
>
>Any ideas ?
>
>thanks,
>-Sheila
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>
>************
From | Date | Subject | |
---|---|---|---|
Next Message | eschmid | 2000-02-20 21:20:59 | Re: [GENERAL] PHP3 and PostgreSQL |
Previous Message | sheila bel | 2000-02-20 20:29:58 | PHP3 and PostgreSQL |