¡@

Home 

php Programming Glossary: lettingunitbookings

Searching for availability with MySQL (and PHP)?

http://stackoverflow.com/questions/1687519/searching-for-availability-with-mysql-and-php

letting units and bookings LettingUnits ID Name etc... LettingUnitBookings ID F_LU_ID Start End Where F_LU_ID is a foreign key to the unit... explain the problem. A LettingUnit 123 Foo Cottage Some LettingUnitBookings 400 123 01 01 09 05 01 09 a 5 day booking 401 123 10 01 09 20.. AS LatestAvailable FROM LettingUnits u LEFT OUTER JOIN LettingUnitBookings b1 ON u.ID b1.F_LU_ID AND b1.End BETWEEN @StartOfWindow AND..