Re: [PHP] BOOKING SYSTEM

2005-09-21 Thread php @ net mines
eas3"]); $thead3 = stripslashes($thes["thead3"]); $theat3 = stripslashes($thes["theat3"]); $theaq3 = stripslashes($thes["theaq3"]); } } if (($theas - $theas3<=0) || ($thead - $thead3<=0) || ($theat - $theat3<=0) || ($theaq - $theaq3<=0)) { $z++; } $

Re: [PHP] BOOKING SYSTEM

2005-09-20 Thread adriano ghezzi
well I did it in the past, at the end after a lot of tests and simulation i decided for warehouse table id_hotel, date, num_total_rooms, num_booked_rooms this is day by day handling it is really flexible you can satisfy each kind of request with very simple queries you also gain more flexibility

[PHP] BOOKING SYSTEM

2005-09-20 Thread php @ net mines
Hi all I have a hotel booking system where for sppecific periods we have specific availability e.g. hotel_id, hotel_name, hotel_fromperiod, hotel_toperiod, hotel_availablesinglerooms 1, Hilton, 20/06/05, 20/08/05, 20 We have a second table for recording the bookings e.g.hotel1_id, hotel1_n