Hi, I'm making a webpage where it allows users to online book like let's say on a hotel, how do I show the users on the site the unfilled slots (dates and time) on the database? I'm using MS Access.
Daigan 0 Junior Poster in Training
LastMitch
@Daigan
I'm using MS Access.
Since you want a unfill slot (dates and time) in database?
Have you created a time slot?
I think you are missing a step.
In order to create a slot you first have to create a slot where it's an unfilled slot show that the hotel is filled.
Another words you need another column for the unfilled slot.
Do you have a query of what you have so far?
adam_k 239 Master Poster
It's not just another column, but a table with slots for each of your resources (if this is a hotel for each of your rooms).
I suggest you show us what you've done already or at least post the relationships, so that we can understand the structure you are using.
LastMitch
It's not just another column, but a table with slots for each of your resources (if this is a hotel for each of your rooms).
Really. I thought it was very simple by add a column but you make a good point about another table with slots for each room. That make more sense. I think Daigan might have to post the code of what he has done so far.
adam_k 239 Master Poster
I knew I had seen a thread about hotel booking a while back: http://www.daniweb.com/web-development/databases/threads/422523/sql-date-question
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.