Online booking system, loading info from one page to another

Question

2.00/5 (1 vote)

See more:

Hello guys. I got really stucked on one thing. I am actually developing an online website booking for a small accommodation. I have a problem. i need the sql code to display the rooms available.
here is the scenario:
we are on the home page. the user select the checkin and checkout date and then he clic search for the room available. I want to load the available rooms in another page.
Any help would be the welcome

here are my tables

reservation table:
reservId
clientId
employeeId
roomNumb
dateIn
dateOut

room table:
roomNumb
roomtypeID
roomRate
floor

roomtype table
roomtypeId
roomType
numberOfPersons

Posted 28-Aug-12 3:36am

Gaetan88

Add a Solution

Comments

Legor 28-Aug-12 9:38am

So where are you stuck at the moment? Nobody here will provide you the code for doing this.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Joan M · Answer 1 · 2012-08-28T04:37:00

So... if the room availability is determined by numberOfPersons, then you should use that field to discriminate the registers and to show only the ones that accomplish a specific rule on that field...

Then reagrding how to select some values in a database, you should see How to use select clause[^].

And how to specify a condition[^] for the select clause.

Once you've done that you will get the result you are after.

Then you'll have to store that result into a recordset in order to work with it.

Try it and come back with details.

Good luck!