Salut!
I\'m working on a small search engine for an internet rental service and got stuck with a quite difficult sql (at least for me) problem, hope one of you can help!
Since the overall thing is quite complicated I\'ll try to simplify it a bit:
Table 1: Homes
(contains all information about the homes we offer etc.
important here: the hid = home id)
Table 2: Occupancy
(contains all information about the renter etc.
important here: every entry is linked to the right home via hid
+ there are 2 fields RentFrom and RentTo which mark the from and enddate of a single rental)
Search Html:
The User can among other options specify the start and enddate in which he\'s interested in here.
So how can i check the Occupancy against the User\'s Search-Query and return the right homes for this timespan with a single SQL statement?
(I know it\'s possible to work around that via PHP, but i need it that way...)
Your help is appreciated!
eph!