prcollin Posted May 15, 2009 Share Posted May 15, 2009 I am creating a reservation program for a buddy of mine. This is what I need A person can check out a boat for up to three days. Say the reserve a boat at 2pm on Friday and they are reserving it until 10am on sunday, how do i make it so that it shows that if someone chooses saturday at 1 pm it shows that that boat is reserved? Link to comment https://forums.phpfreaks.com/topic/158201-calendar-type-help/ Share on other sites More sharing options...
PFMaBiSmAd Posted May 15, 2009 Share Posted May 15, 2009 Store the starting DATETIME and the ENDING data time of the actual reservation in a row, then use the BETWEEN comparison operator to find out if any other DATETIME occurs between the starting and ending DATETIME value - http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between Link to comment https://forums.phpfreaks.com/topic/158201-calendar-type-help/#findComment-834469 Share on other sites More sharing options...
prcollin Posted May 15, 2009 Author Share Posted May 15, 2009 Store the starting DATETIME and the ENDING data time of the actual reservation in a row, then use the BETWEEN comparison operator to find out if any other DATETIME occurs between the starting and ending DATETIME value - http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between so on the same line if i have a display page that has an hourly break down for each day and say someone reserves a boat on 5/5 at 9am and returns it at 5/6 at 11am how do i get it to display that block as reserved for each hour? Link to comment https://forums.phpfreaks.com/topic/158201-calendar-type-help/#findComment-834481 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.