date help and reservation

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
juice
Forum Newbie
Posts: 12
Joined: Tue Feb 01, 2005 9:50 am

date help and reservation

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

look in the MySQL manual about "BETWEEN" syntax-type stuffs.
Post Reply