PHP - Selection code

Following example is using two combobox. which show how to get data from table and echo (print) it. you can make use of it. and first clear the combo box and add new data.


<?php
//**************************************
// Page load dropdown results //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT country FROM $tablename")
or die(mysql_error());

while($tier = mysql_fetch_array( $result ))

{
echo ''.$tier['country'].'';
}

}

//**************************************
// First selection results //
//**************************************
if($_GET['func'] == "country" && isset($_GET['func'])) {
material($_GET['drop_var']);
}

function material($drop_var)
{
include_once('config.php');
$result = mysql_query("SELECT * FROM $tablename WHERE country='$drop_var'")
or die(mysql_error());

echo '';

while($drop_2 = mysql_fetch_array( $result ))
{
echo ''.$drop_2['cities'].'';
}

echo ' ';
// echo '';
}
?>

if you're using them within a form im sure that you would still use the POST method and then pick it up from the next page as $_POST['menuID'] like a normal form... or if it's not a form you could use $_GET though $_POST is better as the info won't show in the address bar 2)

On the select element you have to use the onChange event and trigger the function that will fill the other select 3)

select box 1

<select  name="list1"  id="list1">
  <option  value="">select</option> 
  <option  value="1">option1</option>
  <option  value="2">option2</option> 
  <option  value="3">option3</option> 
  </select>
 
 

your dynamic combo

<div  id="ajax_input">
 <select  name="list2"  id="list2">
 <option  value="">select</option>
 </select>
 </div>
 
 

script

$('#list1').change(function(){
 
  var value  = $(this).val();
 
 $("#ajax_input").load("serverpage.php?value="+value); 
 
 }); 
 
  

you can generate your dynamic select box on

serverpage.php

this will work in

onchange

event not in submit