i have in my table fields frdate and todate.

in my form i have inputs for from and to date, that i want to check if this is already in my table.

say in my table i already have frdate={10/01/2003} and todate={10/12/2003}. if my user inputs from and to date, {10/02/2003} and {10/02/2003} i want to prompt a message that it is already in the table.

i know how to check if a date is in between, between(mydate,frdate,todate). but how to check from and to date if it's in the table already?

pls help.