Page 1 of 1

date help and reservation

Posted: Tue Mar 29, 2005 11:37 am
by juice
jus wondering is there anyy tutorials out there on building a reservation page?
i have three tables, reservation, members and vehicles. I was wondering if anyone can help me with checking availablitiy. how would i go bout comparing dates in php?
for example carID 201 is booked from 03/04/05 to 10/04-05. another member might try and book this during these dates.how do i compare dates in database to check availability?help would be greatful. using php and mysql

Posted: Tue Mar 29, 2005 11:39 am
by feyd
look in the MySQL manual about "BETWEEN" syntax-type stuffs.