Check dates are not already booked

[biggieuk]

Hi, bit of a confusing one.

 

I have dates stored in the database table bookings, fields 'start' and 'end' (YYYY-MM-DD)

 

I then have two dates which the user has selected (YYYY-MM-DD)

 

I need to return the id of all rows where the users selections are not booked in the database if that makes sense?

 

Basically it's cheking to see which rooms are not booked already and returning them.

 

Thanks.

[fenway]

This has been covered many times on these forums -- a simple search should reveal the relevant threads.