Capturing rows selected

[Mary Cunningham]

Hi!
I am trying to write a SQL statement that will select according to a specific criteria and if nothing is found insert a record.

I have tried the SQL_CALC_FOUND_ROWS and then select FOUND_ROWS(). I get the right results, but I don't know how to do anything with those results. I tried putting the FOUND_ROWS() into an IF statement so if it is equal to zero then insert a row, but that failed also.

Thanks in advance for your help!!
Mary