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

Hi everyone, I am a newbie!

I’m doing a little website for booking Water Ski Sessions. It’s a simple little application, the idea is for members to log in and book Water Ski sessions from the available dates and times.

Admins can create session times by completing a form which has the fields skidate, skitime and status, which go into a table called bookings

So they would enter e.g. 21 June 2010, 09:00

I’d like to check the database when the form is completed to see if the skidate and skitime already exists, as obviously a date and time only occurs once (in this universe anyway :slight_smile: )

Any help is greatly appreciated!

Rich :slight_smile:

Sponsor our Newsletter | Privacy Policy | Terms of Service