0

Hi to all,
I have two listboxes, one is state and another is city. As user changes the state, the value of city listbox w.r.t state shuld changed. I do it with using, but I want to do it when user make a selction from state listbox.

//two-list.php

<?php
$con=mysql_connect("localhost","root","");
$db=mysql_select_db('admin');

$state=$_POST['state'];
$city=$_POST['city'];
$submit=$_POST['submit'];

if(!empty($submit))
{
	echo "State selected by you :".$state;
	echo "<br/>";
	echo "State selected by you :".$city;
	echo "<br/>";
	echo "<br/>";
	$insert=mysql_query("insert into state(state,city) values('$state','$city')");
	
}
?>
<body>
<form action="two-list.php" method="post" enctype="multipart/form-data">
<table width="516" align="center">
<tr><td width="99" valign="top">
List One :
</td><td width="217" valign="top">
<select name="state" size="1" id="state">
  <option value="maharashtra">Maharashtra</option>
  <option value="delhi">Delhi</option>
  <option value="gujrat">Gujrat</option>
  <option value="up">UP</option>
  </select>
  </td>
  <td width="84" valign="top">
  List Two :</td>
  <td width="96">
  <?php 
if($state=='maharashtra')
	{
		?>
			<p>Welcome to Maharashtra</p>
			<select size="1" multiple="multiple">
			<option>mumbai</option>
			<option>pune</option>
            <option>nasik</option>
			<option>dhule</option>
			</select>
            <?php
	}
	elseif($state=='delhi')
			{
				?>
<p>Welcome to Delhi</p>
			<select size="1" multiple="multiple">
    		<option>Agra</option>
			<option>Raibareli</option>
			<option>City1</option>
			<option>City2</option>
			</select>
            <?php
	}
	elseif($state=='gujrat')
			{
				?>
<p>Welcome to Gujrat</p>
			<select size="1" multiple="multiple">
			<option>Surat</option>
			<option>Bhuj</option>
			<option>Ahemadabad</option>
			<option>City2</option>
			</select>
            <?php
			}
	else
	        {
				?>
<p>Welcome to Up</p>
			<select multiple="multiple">
			<option>Bihar</option>
			<option>Ratlam</option>
			<option>Indore</option>
			<option>City2</option>
			</select>
			<?php
            } ?>
      </td>
</tr>
<tr><td colspan="7" align="center"><input name="submit" type="submit" id="submit" value="submit" /></td></tr>
</table>
</form>
</body>

How should I do it?

Edited by nav33n: Please use [code][/code] tags to wrap your code for easy readability.

2
Contributors
8
Replies
9
Views
7 Years
Discussion Span
Last Post by manishmannan
0

just do this with the help of java script ok if more help needed kindly post here

thnks, but I dnt know abt scripting.

0

ok let me give you some code please copy and paste this code check it out its working or not

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<script language="javascript"> 
<!-- 
function setOptions(chosen) 
{ 
var selbox = document.myform.opttwo; 
selbox.options.length = 0; 
if (chosen == " ") { 
selbox.options[selbox.options.length] = new Option('Please select one of the options above first',' '); 

} 
if (chosen == "1") { 
selbox.options[selbox.options.length] = new Option('Housekeeping Services'); 
selbox.options[selbox.options.length] = new Option('Garden & Lawn Maintenance');
selbox.options[selbox.options.length] = new Option('Security Services');
selbox.options[selbox.options.length] = new Option('Pest Control');
selbox.options[selbox.options.length] = new Option('Leisure Services / Club Management');
selbox.options[selbox.options.length] = new Option('Mechanical/Electrical Services'); 
selbox.options[selbox.options.length] = new Option('HVAC'); 
selbox.options[selbox.options.length] = new Option('Water Mgmt & Plumbing'); 
selbox.options[selbox.options.length] = new Option('Energy/Safety Services');  
} 
if (chosen == "2") { 
selbox.options[selbox.options.length] = new Option('Property Search'); 
selbox.options[selbox.options.length] = new Option('Sale/Purchase');
selbox.options[selbox.options.length] = new Option('Renting/Leasing'); 
selbox.options[selbox.options.length] = new Option('Documentation');
selbox.options[selbox.options.length] = new Option('Liaison with Govt. Agencies'); 
selbox.options[selbox.options.length] = new Option('Investment Advisory');
selbox.options[selbox.options.length] = new Option('Turnkey Construction');
selbox.options[selbox.options.length] = new Option('Property Custody'); 
selbox.options[selbox.options.length] = new Option('Rent Remittance for Out Station Clients');
} 
if (chosen == "3") { 
selbox.options[selbox.options.length] = new Option('Life Insurance'); 
selbox.options[selbox.options.length] = new Option('Motor Insurance'); 
selbox.options[selbox.options.length] = new Option('House Insurance'); 
selbox.options[selbox.options.length] = new Option('Mediclaim'); 
selbox.options[selbox.options.length] = new Option('Travel Insurance'); 
selbox.options[selbox.options.length] = new Option('Group Insurance'); 
selbox.options[selbox.options.length] = new Option('Mutual Fund'); 
selbox.options[selbox.options.length] = new Option('D-Mat Account'); 
selbox.options[selbox.options.length] = new Option('Company Fixed Deposit'); 
} 
if (chosen == "4") { 
selbox.options[selbox.options.length] = new Option('Airline Ticket Booking'); 
selbox.options[selbox.options.length] = new Option('Railway Ticket Booking');
 selbox.options[selbox.options.length] = new Option('Domestic Tour Packages'); 
selbox.options[selbox.options.length] = new Option('International Tour Packages');
selbox.options[selbox.options.length] = new Option('Travel Insurance'); 
selbox.options[selbox.options.length] = new Option('Passport/Visa Assistance');
} 
} 
--> 
</script>

<body>
<form name="myform" onSubmit="return Validate();" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
          <table cellpadding="5" cellspacing="15" border="0" width="93%" align="left" bgcolor="#eeeeee">
            <tr>
              <td>Name <em>&bull;</em></td>
              <td><input type="text" name="name"></td>
            </tr>
            <tr>
              <td>Address</td>
              <td><textarea name="address"></textarea></td>
            </tr>
            <tr>
              <td>Phone / Mobile No. <em>&bull;</em></td>
              <td><input type="text" name="number"></td>
            </tr>
            <tr>
              <td>City <em>&bull;</em></td>
              <td><input type="text" name="city"></td>
            </tr>
            <tr>
              <td>Country <em>&bull;</em></td>
              <td><select name="Country">
                  <option value="" selected="selected">Select Country</option>
                  <option value="United States">United States</option>
                  <option value="United Kingdom">United Kingdom</option>
                  <option value="Afghanistan">Afghanistan</option>
                  <option value="Albania">Albania</option>
                  <option value="Algeria">Algeria</option>
                  <option value="American Samoa">American Samoa</option>
                  <option value="Andorra">Andorra</option>
                  <option value="Angola">Angola</option>
                  <option value="Anguilla">Anguilla</option>
                  <option value="Antarctica">Antarctica</option>
                  <option value="Antigua and Barbuda">Antigua and Barbuda</option>
                  <option value="Argentina">Argentina</option>
                  <option value="Armenia">Armenia</option>
                  <option value="Aruba">Aruba</option>
                  <option value="Australia">Australia</option>
                  <option value="Austria">Austria</option>
                  <option value="Azerbaijan">Azerbaijan</option>
                  <option value="Bahamas">Bahamas</option>
                  <option value="Bahrain">Bahrain</option>
                  <option value="Bangladesh">Bangladesh</option>
                  <option value="Barbados">Barbados</option>
                  <option value="Belarus">Belarus</option>
                  <option value="Belgium">Belgium</option>
                  <option value="Belize">Belize</option>
                  <option value="Benin">Benin</option>
                  <option value="Bermuda">Bermuda</option>
                  <option value="Bhutan">Bhutan</option>
                  <option value="Bolivia">Bolivia</option>
                  <option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option>
                  <option value="Botswana">Botswana</option>
                  <option value="Bouvet Island">Bouvet Island</option>
                  <option value="Brazil">Brazil</option>
                  <option value="British Indian Ocean Territory">British Indian Ocean Territory</option>
                  <option value="Brunei Darussalam">Brunei Darussalam</option>
                  <option value="Bulgaria">Bulgaria</option>
                  <option value="Burkina Faso">Burkina Faso</option>
                  <option value="Burundi">Burundi</option>
                  <option value="Cambodia">Cambodia</option>
                  <option value="Cameroon">Cameroon</option>
                  <option value="Canada">Canada</option>
                  <option value="Cape Verde">Cape Verde</option>
                  <option value="Cayman Islands">Cayman Islands</option>
                  <option value="Central African Republic">Central African Republic</option>
                  <option value="Chad">Chad</option>
                  <option value="Chile">Chile</option>
                  <option value="China">China</option>
                  <option value="Christmas Island">Christmas Island</option>
                  <option value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option>
                  <option value="Colombia">Colombia</option>
                  <option value="Comoros">Comoros</option>
                  <option value="Congo">Congo</option>
                  <option value="Congo, The Democratic Republic of The">Congo, DMR</option>
                  <option value="Cook Islands">Cook Islands</option>
                  <option value="Costa Rica">Costa Rica</option>
                  <option value="Cote D'ivoire">Cote D'ivoire</option>
                  <option value="Croatia">Croatia</option>
                  <option value="Cuba">Cuba</option>
                  <option value="Cyprus">Cyprus</option>
                  <option value="Czech Republic">Czech Republic</option>
                  <option value="Denmark">Denmark</option>
                  <option value="Djibouti">Djibouti</option>
                  <option value="Dominica">Dominica</option>
                  <option value="Dominican Republic">Dominican Republic</option>
                  <option value="Ecuador">Ecuador</option>
                  <option value="Egypt">Egypt</option>
                  <option value="El Salvador">El Salvador</option>
                  <option value="Equatorial Guinea">Equatorial Guinea</option>
                  <option value="Eritrea">Eritrea</option>
                  <option value="Estonia">Estonia</option>
                  <option value="Ethiopia">Ethiopia</option>
                  <option value="Falkland Islands (Malvinas)">Falkland Islands (Malvinas)</option>
                  <option value="Faroe Islands">Faroe Islands</option>
                  <option value="Fiji">Fiji</option>
                  <option value="Finland">Finland</option>
                  <option value="France">France</option>
                  <option value="French Guiana">French Guiana</option>
                  <option value="French Polynesia">French Polynesia</option>
                  <option value="French Southern Territories">French Southern Territories</option>
                  <option value="Gabon">Gabon</option>
                  <option value="Gambia">Gambia</option>
                  <option value="Georgia">Georgia</option>
                  <option value="Germany">Germany</option>
                  <option value="Ghana">Ghana</option>
                  <option value="Gibraltar">Gibraltar</option>
                  <option value="Greece">Greece</option>
                  <option value="Greenland">Greenland</option>
                  <option value="Grenada">Grenada</option>
                  <option value="Guadeloupe">Guadeloupe</option>
                  <option value="Guam">Guam</option>
                  <option value="Guatemala">Guatemala</option>
                  <option value="Guinea">Guinea</option>
                  <option value="Guinea-bissau">Guinea-bissau</option>
                  <option value="Guyana">Guyana</option>
                  <option value="Haiti">Haiti</option>
                  <option value="Holy See (Vatican City State)">Holy See (Vatican City State)</option>
                  <option value="Honduras">Honduras</option>
                  <option value="Hong Kong">Hong Kong</option>
                  <option value="Hungary">Hungary</option>
                  <option value="Iceland">Iceland</option>
                  <option value="India">India</option>
                  <option value="Indonesia">Indonesia</option>
                  <option value="Iran, Islamic Republic of">Iran, Islamic Republic of</option>
                  <option value="Iraq">Iraq</option>
                  <option value="Ireland">Ireland</option>
                  <option value="Israel">Israel</option>
                  <option value="Italy">Italy</option>
                  <option value="Jamaica">Jamaica</option>
                  <option value="Japan">Japan</option>
                  <option value="Jordan">Jordan</option>
                  <option value="Kazakhstan">Kazakhstan</option>
                  <option value="Kenya">Kenya</option>
                  <option value="Kiribati">Kiribati</option>
                  <option value="Korea">Korea</option>
                  <option value="Korea">Korea</option>
                  <option value="Kuwait">Kuwait</option>
                  <option value="Kyrgyzstan">Kyrgyzstan</option>
                  <option value="Lao">Lao</option>
                  <option value="Latvia">Latvia</option>
                  <option value="Lebanon">Lebanon</option>
                  <option value="Lesotho">Lesotho</option>
                  <option value="Liberia">Liberia</option>
                  <option value="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</option>
                  <option value="Liechtenstein">Liechtenstein</option>
                  <option value="Lithuania">Lithuania</option>
                  <option value="Luxembourg">Luxembourg</option>
                  <option value="Macao">Macao</option>
                  <option value="Macedonia">Macedonia</option>
                  <option value="Madagascar">Madagascar</option>
                  <option value="Malawi">Malawi</option>
                  <option value="Malaysia">Malaysia</option>
                  <option value="Maldives">Maldives</option>
                  <option value="Mali">Mali</option>
                  <option value="Malta">Malta</option>
                  <option value="Marshall Islands">Marshall Islands</option>
                  <option value="Martinique">Martinique</option>
                  <option value="Mauritania">Mauritania</option>
                  <option value="Mauritius">Mauritius</option>
                  <option value="Mayotte">Mayotte</option>
                  <option value="Mexico">Mexico</option>
                  <option value="Micronesia">Micronesia</option>
                  <option value="Moldova">Moldova</option>
                  <option value="Monaco">Monaco</option>
                  <option value="Mongolia">Mongolia</option>
                  <option value="Montserrat">Montserrat</option>
                  <option value="Morocco">Morocco</option>
                  <option value="Mozambique">Mozambique</option>
                  <option value="Myanmar">Myanmar</option>
                  <option value="Namibia">Namibia</option>
                  <option value="Nauru">Nauru</option>
                  <option value="Nepal">Nepal</option>
                  <option value="Netherlands">Netherlands</option>
                  <option value="Netherlands Antilles">Netherlands Antilles</option>
                  <option value="New Caledonia">New Caledonia</option>
                  <option value="New Zealand">New Zealand</option>
                  <option value="Nicaragua">Nicaragua</option>
                  <option value="Niger">Niger</option>
                  <option value="Nigeria">Nigeria</option>
                  <option value="Niue">Niue</option>
                  <option value="Norfolk Island">Norfolk Island</option>
                  <option value="Northern Mariana Islands">Northern Mariana Islands</option>
                  <option value="Norway">Norway</option>
                  <option value="Oman">Oman</option>
                  <option value="Pakistan">Pakistan</option>
                  <option value="Palau">Palau</option>
                  <option value="Palestinian Territory">Palestinian Territory</option>
                  <option value="Panama">Panama</option>
                  <option value="Papua New Guinea">Papua New Guinea</option>
                  <option value="Paraguay">Paraguay</option>
                  <option value="Peru">Peru</option>
                  <option value="Philippines">Philippines</option>
                  <option value="Pitcairn">Pitcairn</option>
                  <option value="Poland">Poland</option>
                  <option value="Portugal">Portugal</option>
                  <option value="Puerto Rico">Puerto Rico</option>
                  <option value="Qatar">Qatar</option>
                  <option value="Reunion">Reunion</option>
                  <option value="Romania">Romania</option>
                  <option value="Russian Federation">Russian Federation</option>
                  <option value="Rwanda">Rwanda</option>
                  <option value="Saint Helena">Saint Helena</option>
                  <option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option>
                  <option value="Saint Lucia">Saint Lucia</option>
                  <option value="Saint Pierre and Miquelon">Saint Pierre and Miquelon</option>
                  <option value="Samoa">Samoa</option>
                  <option value="San Marino">San Marino</option>
                  <option value="Sao Tome and Principe">Sao Tome and Principe</option>
                  <option value="Saudi Arabia">Saudi Arabia</option>
                  <option value="Senegal">Senegal</option>
                  <option value="Serbia and Montenegro">Serbia and Montenegro</option>
                  <option value="Seychelles">Seychelles</option>
                  <option value="Sierra Leone">Sierra Leone</option>
                  <option value="Singapore">Singapore</option>
                  <option value="Slovakia">Slovakia</option>
                  <option value="Slovenia">Slovenia</option>
                  <option value="Solomon Islands">Solomon Islands</option>
                  <option value="Somalia">Somalia</option>
                  <option value="South Africa">South Africa</option>
                  <option value="Spain">Spain</option>
                  <option value="Sri Lanka">Sri Lanka</option>
                  <option value="Sudan">Sudan</option>
                  <option value="Suriname">Suriname</option>
                  <option value="Svalbard and Jan Mayen">Svalbard and Jan Mayen</option>
                  <option value="Swaziland">Swaziland</option>
                  <option value="Sweden">Sweden</option>
                  <option value="Switzerland">Switzerland</option>
                  <option value="Syrian Arab Republic">Syrian Arab Republic</option>
                  <option value="Taiwan, Province of China">Taiwan, Province of China</option>
                  <option value="Tajikistan">Tajikistan</option>
                  <option value="Tanzania, United Republic of">Tanzania, United Republic of</option>
                  <option value="Thailand">Thailand</option>
                  <option value="Timor-leste">Timor-leste</option>
                  <option value="Togo">Togo</option>
                  <option value="Tokelau">Tokelau</option>
                  <option value="Tonga">Tonga</option>
                  <option value="Trinidad and Tobago">Trinidad and Tobago</option>
                  <option value="Tunisia">Tunisia</option>
                  <option value="Turkey">Turkey</option>
                  <option value="Turkmenistan">Turkmenistan</option>
                  <option value="Turks and Caicos Islands">Turks and Caicos Islands</option>
                  <option value="Tuvalu">Tuvalu</option>
                  <option value="Uganda">Uganda</option>
                  <option value="Ukraine">Ukraine</option>
                  <option value="United Arab Emirates">United Arab Emirates</option>
                  <option value="United Kingdom">United Kingdom</option>
                  <option value="United States">United States</option>
                  <option value="Uruguay">Uruguay</option>
                  <option value="Uzbekistan">Uzbekistan</option>
                  <option value="Vanuatu">Vanuatu</option>
                  <option value="Venezuela">Venezuela</option>
                  <option value="Viet Nam">Viet Nam</option>
                  <option value="Virgin Islands, British">Virgin Islands, British</option>
                  <option value="Virgin Islands, U.S.">Virgin Islands, U.S.</option>
                  <option value="Wallis and Futuna">Wallis and Futuna</option>
                  <option value="Western Sahara">Western Sahara</option>
                  <option value="Yemen">Yemen</option>
                  <option value="Zambia">Zambia</option>
                  <option value="Zimbabwe">Zimbabwe</option>
                </select>
              </td>
            </tr>
            <tr>
              <td>E-mail Address <em>&bull;</em></td>
              <td><input type="text" name="email"></td>
            </tr>
            <tr>
              <td>Category <em>&bull;</em></td>
              <td><select name="optone" size="1" style="width:200px;"  
onchange="setOptions(document.myform.optone.options[document.myform.optone.selectedIndex].value);"> 
<option value="" selected="selected"> </option> 
<option value="1" >Facility Management</option> 
<option value="2">Real Estate</option> 
<option value="3">Financial Services</option> 
<option value="4">Travel Services</option> 
              </select>
              </td>
            </tr>
            
            <tr>
              <td>Sub Category <em>&bull;</em></td>
              <td><select name="opttwo" size="1" style="width:200px;"> 
<option value=" " selected="selected"></option> 
</select> 

              </td>
            </tr>
            <tr>
              <td>Describe your query</td>
              <td><textarea name="req" id="req"></textarea></td>
            </tr>
				<tr>
		  <td>
		  </td>
		  </tr>
			<tr>
			<td colspan="2" align="center">
			<input class="btns" type="reset" value="RESET">&nbsp;<input  class="btns" type="submit" value="SUBMIT"></td>
			</tr>
		
			<tr>
			<td colspan="2" class="mand"><em>&bull;</em> fields are mandatory.</td>
          </tr>
		  
		  </table>
        </form>
</body>
</html>

Edited by nav33n: Please use [code][/code] tags to wrap your code for easy readability.

0

or more help needed kindly mail me <snipped>

Edited by nav33n: Email snipped. Read forum rules. Keep it on the site.

0

Hello Manish,
Will you please tell me more about 'action' method of your code, <form name="myform" onSubmit="return Validate();" action="<?php echo $_SERVER; ?>" method="post">

0

Hello Manish,
Your code is just amazing, will you please explain about scripting. I dnt know know anything about scripting. Will you please tell me about basic tutorials about scripting in simple english which contain basic scripting chapters?
Also, is there any other way to deal with my question?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.