Jump to content

Calendar type help


prcollin

Recommended Posts

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.