Checking to see if a date and time exists in a table

Hi there

I am making a basic application for booking Water Skiing sessions. The administrator can log in and add session times, i.e. 01 August 2010 09:00 for members to book.

Obviously as the administrator add’s times, I don’t want them to be able to add the time twice

So I have a table with fields

skidate, skitime and status , and a form with fields skidate, skitime and status

How can I make the form check on the skidate and skitime to see if it’s already there…

Thanks in advance

Rich :slight_smile:

Sponsor our Newsletter | Privacy Policy | Terms of Service