When searches don't find any data?

[puffer]

I've created a php script that queries a table I've created with Oracle. When I want to display the returned search array, I print some header columns in html, then do a while statement that loops through the returned search array until it's empty, with the returned info placed neatly below the header columns.
The problem is that if I enter a search string that doesn't exist in my table, the script that displays the returned array displays the header columns with nothing in the rows below. I realized I needed to test my header columns to see if the returned search array was empty. If it was, I didn't want to print the column headers in my html page. Plus I would like to print out a message to tell the user that no information was found, and to try again.

But I've looked everywhere over the past 2 weeks, and tried all the Oracle functions I could find concerning rows, columns, and not null values. I need to find some value or returned variable or something that would just tell me if my search didn't find a match in my table. Does anyone know of anything?

Chuck
[e-mail]

[jeremuck]

you are probably getting your results at the top of a loop, right?
Change your pre-test loop to a post-test loop
use:

getFirstResults or die(print "Sorry, no records");

print headers

do
{

//Extract results to html

} while(gettingthenextresults);

I'm not certain about Oracle functions, but this is how I would do it in MySQL. But this model will allow you to test if there were any results before you print the header for the table.

[puffer]

Thanks for responding.
I know how I want the script to work as far as the flow of control goes, I just don't have the Oracle function or variable or code to make the actual test for the empty return array against.

[jeremuck]

ocifetch(integer statement);

The ocifetch function prepares the next row of data to be read with ociresult. When no rows remain, FALSE is returned.

[puffer]

I finally got it working, but not like I thought I would.
I was using the OCIFetchInto function in a while loop to print out the returns of the query, but when I used OCIFetchInto as a test to see if there was any data returned, and therefore to print the header columns or not, it removed the first record to display. So when I ran through the while loop, the first record it should have displayed was always missing. So I just fixed the code so that it printed the table headers and the first record if there was any records returned at all, then, if there was more than one record returned, a while loop to churn out the rest, all nice and pretty under the header columns.

Thanks