hi all,
i made two commbox in my page cropcat,subcat.my coding is below.when i select a item form cropcat related subcat fetch from database mysql and displayed.but my problem here is that when i select item form cropcat page refresh and selected value not display in cropcat ?please help me

<form name="form1" id="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="18%">&nbsp;</td>
    <td width="71%">&nbsp;</td>
    <td width="5%">&nbsp;</td>
    <td width="6%">&nbsp;</td>
  </tr>
  <tr>
    <td><select name="cropcat" id="cropcat" onchange=oneG()>
            <option value="0">Select Crop...</option>
            <option value="OffSeasonVEG">OffSeasonVEG</option>
            <option value="MedicinalPlants">MedicinalPlants</option>
            <option value="Floriculture">Floriculture</option>
            <option value="Pulses">Pulses</option>
          </select></td>
		  
    <td><span class="style121">
     <?php
    // echo "Connected MySql";
	$cc=$_POST['cropcat'];
	//echo "ccc".$cc;
  $res1 = mysql_query("SELECT subcat FROM crop_detail where cropcat='$cc'") or die("Invalid query: " . mysql_query());
  //echo ".mysql_query()";
  echo '<select  id="gp" name="gp" onchange=oneG()>';
  echo '<option value="">select...</option>';
  while ($row1= mysql_fetch_array($res1)) 
  {
     $g = $row1['subcat'];
     echo "<option value='$g'>$g</option>";
  }
  echo '</select>';
 ?>
    </span></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>
..................
<script language="javascript">
function oneG()
{
	document.form1.submit();
}
</script>

the one that is selected is in $_POST. You can use it to add the selected attribute of one of the options.

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.