Re: oracle exec
| From: | heinisch at creaction dot de | Date: | Mon, 25 Mar 2002 21:04:24 +0000 |
| Subject: | Re: oracle exec | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-90095@lists.php.net to get a copy of this message | ||
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