At 25.03.2002  15:10, you wrote:
>
>
>hi.. is there any way to use the php oracle function to check to see if
>there are any records in the selected set before calling ora_fetch?
>ora_exec doesn't error if ther are no records, and ora_num_rows doesn't
>return the numbe of rows in the set.,
>
>thanks!
>matt
Seems that there´s no short way,
just have a 'select count(your_id_col) from footable where ...'
This will bring the number of records.
As a tip, use this var to get your results in an for(....) statement,
as there is no way tho catch errors if you use while(..).
(OCI functions, PHP3)

HTH Oliver


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to