two commbox problem

Expand Post »

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

PHP Syntax (Toggle Plain Text)
 
                          <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>
  
                          <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>

Last edited by peter_budo; Nov 5th, 2008 at 9:00 pm. Reason: Correcting code tags, please use [code] not <code>

rohitrohitrohit

Reputation Points: 15

Solved Threads: 5

Junior Poster

Offline

120 posts
since Oct 2007

Permalink

Nov 5th, 2008

Re: two commbox problem

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

pritaeas

Sponsor

Featured Poster

Reputation Points: 549

Solved Threads: 722

Bite my shiny metal ass!

Offline

4,156 posts
since Jul 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Form Validation ???

Next Thread in PHP Forum Timeline: How to make website submitter??

DaniWeb Message

Cancel Changes

User Name
Password