PHP help on dropdown list with database value

Question

1.00/5 (1 vote)

See more:

Hello ,

I am developing one project in php in which there are two tables as city(city_id, city_name) and hotel(hotel_id, city_id, hotel_name). The php page contains two drop down list in which 1st drop down list contains the list cities and 2nd drop down list contains the hotels in the selected city(from 1st drop down list)
Please help me for this project.

Posted 1-Sep-13 3:50am

Prachi92

Add a Solution

Comments

Nelek 1-Sep-13 16:18pm

Please don't think we can read minds or do astral projections to see your monitor. If you need help, the least you could do is to add some relevant code to your question or to explain your problem in such a way, that the users of CP can understand it. Otherwise, nobody will be able to help you.

Since you didn't ask any question, it is difficult to give you a better answer.

I strongly recommend you to read:
How to ask a question[^] and What have you tried?[^]

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)

Antony Lloyd · Accepted Answer · 2013-09-01T09:35:00

Firstly, get the value of the city. The value of the option should be the city ID. Then query the data base for the city_id in the hotel table, then return the results. E.g.

PHP

$cityId = $_POST['city']; // Get the city id from the drop down

$result = mysql_query("SELECT * FROM `hotel` WHERE `city_id` = '".$cityId."'"); // Query the data base for hotels containing the city_id

if($result) // Some error checking
{
     if(mysql_num_rows($result) == 0) // If there are no entries, say so
           echo "<option>There are no hotels!</option>";
     else
     {
           // Return all of the entries
           while($hotel = mysql_fetch_array($result)
           {
                echo "<option value="".$hotel["hotel_id"]."">".$hotel["hotel_name"]."</option>";
           }
     }
}