Hi, I have two columns in my table in date format: Booking_Start_Date and Booking_End_Date. When a user confirms a booking they enter the start date and the number of days for the booking, however bookings cannot occur on a Saturday or a Sunday. So if a user enters a start date which is on a Friday and the booking is for two days, how can i formulate the query so that MySQL will make sure the booking ends on the Monday? Thanks for your advice -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
