I really did not want to post this request, since I think it might be too complicated, well, even to explain. So, if some could crack this for me, PLEASE.
I have searched the web for ages now, and tried several scripts and even tried to figure out the code of existing scripts, but everything that I got on the net, is either too bloated or far from what I am looking for.
I tried to get something together to post this together with this posting, but since I have no idea, I really can't add anything.
Well, let me try to explain. I just want a very very simple script/code.
Lets say I have 5 rooms. Now the only thing that I'd like to achieve, is to see whether the room is available to book or not, by getting the dates booked from my mysql database.
Well, since I don't have a clue, I thought that it might work if I select the dates booked from the database.
Ok, let me put it this way. I can achieve viewing all the dates booked, but I don want to achieve this. I want to enter 2 dates, and after submitting the dates, I want to see which rooms are available or not.
Since it is not effective to create a table and enter all the possible dates, and just define whether it is available or not. So I guess that I have to try something whereby the script will display all the rooms not booked, in other words, rooms with no dates tagged.
I can;t really try to put down a method or a way to do this, because I've flattered my brains already and can't find a solution.
So please, please, if anybody can just assist me here.
I just want to define lets say 5 rooms. And I'd like to enter the dates into the sql database where the rooms are booked. So then I'd like to enter 2 different dates, ie. arrival and departure, and when submitting, I have to see the available rooms only.
All my hopes,