close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dynamic dropdown filter results on page

Thread began 10/26/2009 3:09 pm by hnewsom391969 | Last modified 10/29/2009 7:01 pm by Jason Byrnes | 1903 views | 5 replies |

hnewsom391969

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

hnewsom391969

Dynamic dropdown filter results on page

Originally Said By: Jason Byrnes
  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>

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

hnewsom391969

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...