Dynamic dropdown filter results on page
Hi,
I'm having a difficult time trying to create a dynamic drop like the following:
form-order-now.php
Can you give me some assistance?
Hi,
I'm having a difficult time trying to create a dynamic drop like the following:
form-order-now.php
Can you give me some assistance?
what part are you having problems with?
the child parent dropdowns will be fairly strait forward.
You will need to use javascript to submit te form when a selection is made in the child list and filter a record set on the selections made to show the prices for that selection.
Here is all I have thus far...
INCORPORATION STATE FEE</font></p>
<form id="form1" method="post" action="">
<select name="Business Entity" id="Business Entity" accesskey="1" tabindex="b">
<option value="Select Business Type">Select Business Type</option>
<option value="INC">INC</option>
<option value="LLC">LLC</option>
<option value="Non Profit">Non Profit</option>
</select>
</form>
<p><font color="#FF0000" face="Book Antiqua"></font></p>
<form id="form2" method="post" action="">
<select name="State" id="State" accesskey="2" tabindex="s">
<option value="Select State" selected="selected">Select State</option>
<option value="Alabama">Alabama</option>
<option value="Alaska">Alaska</option>
<option value="Arizona">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="D.C.">D.C.</option>
<option value="Delaware">Delaware</option>
<option value="Florida ">Florida </option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho ">Idaho </option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missouri">Missouri</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma ">Oklahoma </option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvania ">Pennsylvania </option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virginia">Virginia</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>
</select>
</form>
<p>
first off, you have two seperate forms, each select list should be in the same form.
to do this using static dropdown menus you will need to hand code the javascript to get them working the way you way want.
Dynamic Dropdowns use information from a database to drill down related data.
Looking at the select lists you have posted, i do not see how the data in the parent list relates to the data in the child list.
Okay, I've made changes but I still cannot acheive my objective of selecting business type and State from dropdowns to get a $ fee in a text field. I also have a add to list and remove button. here is my code:
<form id="form1" method="post" action="">
<p>
<select name="parent" size="1" id="parent" onchange="WA_FilterAndPopulateSubList(Child_WAJA,MM_findObj('parent'),MM_findObj('child'),0,0,false,': ')">
<?php
do {
?>
<option value="<?php echo $row_Parent['ParentID']?>"><?php echo $row_Parent['BusinessEntity']?></option>
<?php
} while ($row_Parent = mysql_fetch_assoc($Parent));
$rows = mysql_num_rows($Parent);
if($rows > 0) {
mysql_data_seek($Parent, 0);
$row_Parent = mysql_fetch_assoc($Parent);
}
?>
</select>
<select name="child" size="1" id="child">
</select>
<select name="target" size="1" id="target">
</select>
<input name="add" type="button" id="add" onclick="WA_AddSubToSelected(MM_findObj('child'),MM_findObj('target'),false,false,false,0,0,'0','')" value="Add to List" />
<input name="remove" type="button" id="remove" onclick="WA_RemoveSelectedFromList(MM_findObj('target'),'|WA|0|WA|',-1,'0','None Selected')" value="Remove" />
</p>
</form>
<p
Once they select the business type and state, the form will need to be submitted.
Create recordset that filters your price table on the the selected State ID and bussiness ID to return the price and add it to the text box.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.