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