Inserting two dates
| From: | shaun | Date: | Mon, 21 Apr 2003 12:59:06 +0000 |
| Subject: | Inserting two dates | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27221@lists.php.net to get a copy of this message | ||
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