hyee...
i am working on a web based for online reservation for sports venue. My problem is i dunno how to disabled the time that already being reserved by other member. For example if user reserved the venue from 9.00 am to 10.00am... nobody can reserve the same time. They have to choose other time. In other words my web page will display only the available time. Another problem is i dunno how to make autosum the hours based on reservation time entered by member... for example... time start :9.00am time end:10.00am = 2 hours .... i dunno how to make it automatically 2 hours and etc.

And i need your advise on how to create table in order to store available time for reservation purpose.


I am using Dreamweaver MX 2004, MySQL-Front 2.2, and APACHE server.


Please help me.... i cant find anybody to help me regarding this problem. <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>


regards,
nat