[RESOLVED] How to display data from 2 comboboxes

[saraa]

hi all..i want to display fax data which choosed from 2 comboboxes.
one is branch and the other one is month.
The problem here i dont know how to bring a branch value when i choose month..
When i choose a month, it not brings a value of branch together..
Here is my codings.


<?
$month1=$_GET['Month'];
$branch_id=$_GET['branch'];

$queryB = mysql_query("SELECT * FROM branch WHERE code='$branch_id'");
$br=mysql_fetch_array($queryB);
$idB= $br['code'];
$nB=$br['name'];
?>

<form name="form1" id="form1" action="faxin2.php" method="get">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="3" >
<tr>
<td><div align="right"></div></td>
<td>&nbsp;</td>
<td align="center">Branch: <select name="branch" onChange="this.form.submit()">
<option value="">Select Branch</option>

<?
$sqlst = mysql_query("SELECT * FROM branch ORDER BY name");
while($branch = mysql_fetch_array($sqlst)){ ?>
<option value="<? echo $branch['code'] ?>"><? echo $branch['name'] ?>
</option>
<? } ?>
</select>&nbsp;<input type="text" name="branch_id" value="<? echo $branch_id;?>"><? echo $nB;?>

<select name="Month" id="Month" onChange="this.form.submit()">
<option value="">Select Month</option>
<option>January</option>
<option>February</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>&nbsp;
<input type="submit" name="Submit" value="Show"></td>
</tr>
<tr>
<td colspan="5">&nbsp;&nbsp;</td>

</tr>
</table>
</form>


Please letme know how to solve this problem..thanks in advance

[kows]

I'm a little confused as to what you want to do. from the javascript you're using on the <select> events, I assume you want to submit the form after picking a branch and month. to do this better, you should probably only have the "onchange" event on the month's <select>, not both. otherwise, whenever you pick a branch you will have the form submitted (and you will not have the chance to pick a month); and likewise, if you picked the month first, you wouldn't have a chance to pick the branch. you will probably need a bit more advanced javascript than this because you'll want to check to see if both <select>'s values are defined, and then you can submit. either way, I generally don't like self-submitting things like this, so I would advise that you just get rid of the javascript events you're using and stick to the "show" button that you have. as far as I can understand, this thing where when you pick one it automatically submits is your problem -- because it automatically submits the form before you have a chance to pick the other values.

[saraa]

I'm a little confused as to what you want to do. from the javascript you're using on the <select> events, I assume you want to submit the form after picking a branch and month. to do this better, you should probably only have the "onchange" event on the month's <select>, not both. otherwise, whenever you pick a branch you will have the form submitted (and you will not have the chance to pick a month); and likewise, if you picked the month first, you wouldn't have a chance to pick the branch. you will probably need a bit more advanced javascript than this because you'll want to check to see if both <select>'s values are defined, and then you can submit. either way, I generally don't like self-submitting things like this, so I would advise that you just get rid of the javascript events you're using and stick to the "show" button that you have. as far as I can understand, this thing where when you pick one it automatically submits is your problem -- because it automatically submits the form before you have a chance to pick the other values.Thanks a lot Mr.kow..i got it now