Dynamic Drop Down List Based On Text Field Value
Nov 25, 2009
I have a form that has a pretty complicated combo box - a user starts typing text, it queries a database for matches, and displays the results to the user. The user can then select the match they desire and it has a value id, which I am currently sending to a hidden field in the form. So, for example: user starts typing in a movie name, Seven - it returns Seven and user selects it. The form submits the id of the movie seven (say 12) to a hidden field.
Where I am stumped: Once a user selects a movie title, I have another drop down select box that is to display the available formats of the movie by querying my database based on the product id (12) and returning the available formats in the list:
DVD
BLUERAY
VHS
I am pretty good at programming, but I cannot figure this out - how to make the select box fire and return results once the value for the textbox has been captured.
View 1 Replies
ADVERTISEMENT
Jun 29, 2010
how to populate a dropdown based on Another dropdown selection. This all should be a dynamic. Eg: I have two text boxes one is TechID and other is JOB ID. When I start typing Tech ID it suggests me the list of IDs which start with the input string i have put in Tech textbox. When i select the Tech ID the jobs associated to that Tech ID should be displayed in JOB ID text box as a dropdown list.
View 1 Replies
View Related
Jun 30, 2009
I've been beating my head against a wall for a few days trying to get this working. I'm trying to create a dynamic menu where a user selects one item and another select list is shown, then another and another (and so on). Here is my JS, it *should* be taking the ID of the div, comparing it to the selected value and then showing another div by settings it's class property to visible:
[Code]...
View 1 Replies
View Related
May 10, 2007
I'm looking for have a text field when a user clicks in the text field a drop list of values appears for the user selects from and populates the text box they clicked. Is there anywhere I can find this or something similar?
View 1 Replies
View Related
May 1, 2009
how to create a somewhat simple form. The form will have text fields for 'Name', 'Phone', etc. What I want is to have a drop down list, which has different insurances to choose from (i.e. Medical Insurance, Dental Insurance, Senior products), and say when I choose 'Senior Products', new text fields pop up within the form to add their 'Address' and click a checkbox that states they authorize to be contacted. These new fields aren't visible unless they choose 'Senior Products' from the drop down list.
View 6 Replies
View Related
Jul 20, 2005
I'm trying to show/hide a simple piece of text and a text field on a
form based on what choice is made from a drop down box.
<select name="dropdown" size="1">
<option selected value="">Please make a selection</option>
<option value="1">Choice 1</option>
<option value="2">Choice 2</option>
<option value="3">Choice 3</option>
<option value="4">Other</option>
</select>
i.e. if Choice 2 is selected I'd like to display a new <tr> with the
following:
<tr>
<td>New text field:</td>
<td><input name="newField" type="text size="20"></td>
</tr>
if any other choices are made, I don't want to display anything.
I've tried several onchange() functions but can't achieve what I'm
looking for.
View 6 Replies
View Related
Dec 3, 2009
I have set up my website quite some time ago that has served its purpose very well, however I will now be adding an order form functionality. So far, by reading books and traversing forums, I have been able to develop a page where the user
1.Enters data into the required fields, that is then submitted to a MYSQL database via PHP,
2.Can retrieve orders that are stored in the database,
3.Delete orders that are stored in the database.
I have wamp installed on my computer as the webserver. I have also incorporated two drop down lists that both retrieve their values from tables within the database. The first drop down list retrieves the Australian States that I have stored in a table, and once the submit button is pressed, it stores the State that is selected to a separate table. This drop down list functions as it should. An extract from "From Place an order.php"
<?php
$dbcnx = @mysql_connect('localhost', 'root', 'tingling');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
} .....
The second drop down list retrieves product names from a table that contains products and their prices. What I would like to happen, is that when the product is selected from this drop down list, a text box is automatically filled with its corresponding price. I had this drop down list working as per the "States" drop down list, but could not get it to auto populate the text field. I got some assistance from a friend and was able to get the text box to auto populate with its corresponding price, however when the page was submitted to the database, the "id" number of the product name from the drop down list was stored, and not the product name.
<select name="productSelection" onchange = "getProductDetails(this)">
<option selected value="1product">Select Product</option>
<?php
$products1 = @mysql_query('SELECT * FROM products');
if (!$products1) {
exit('<p>Unable to obtain author list from the database.</p>'); .....
View 9 Replies
View Related
Jun 9, 2009
I have a page that displays a list of people playing in a tournament. I need to be able to generate a Leaderboard based on which players are manually selected by the admin. Next to each person there is a drop-down list. An admin can go in and select a "slot" that a player should be in on the leader board from 1 to 8, or leave it blank if none. What I need to figure out how to do is the following, when a change event happens on a drop-down list, and say the value 5 is selected, I need to check to make sure that 5 is not already selected in one of the other players drop-down lists, in other words, that the 5th leaderboard slot is not already full. if it is, display an error message and make them change that one first. how to do that with jQuery? I'm thinking it will have something to do with the each() function, but not sure exactly how the logic should work.
View 4 Replies
View Related
Aug 2, 2011
I have a table that has parts with multiple characteristics. Part Number, Height, Width, Capacity, Price, Etc. I would like to have a drop downs for all of these values, when a user selects one of these values it will filter the results into a list. Ex. user selects a part that has a Height of 6 and width of 10 it will only list those parts. As I said earlier, I have a script that will give me all the parts, however I am not able to make the onchange list parts with multiple values.
View 9 Replies
View Related
Mar 7, 2008
I'm trying to create a dynamic drop down box where the first drop down box populates the second drop down, but it isn't working. I have two tables; pricelist with fields,
-id
-groupname
-item
-price
groups with fields,
-id
-groupname
I've got the code and to me it looks as though it completely works, but i think its the fact that two of the fields have the same name, and it's causing problems.
[Code]...
View 6 Replies
View Related
Oct 2, 2009
I am trying to populate a drop down list in an HTML form that pulls it's data from a datbase. Basically, the users can manage the values via a differnt interface, but the web page will present what ever values are in a given list. I can make the list from the database as a set of value pairs, but I can't figure out how to take that list and "import it" into an HTML page. I didn't post any code since nothing comes close to working. If I have this list:
Item, Name
A001, Cats
A002, Dogs
A003, Birds
what do I do to pull this into a form?
View 6 Replies
View Related
Nov 30, 2004
i have created a dynamic menus for ie, with the div tag......... it works fine,, but when it comes over the drop down list box.... the part goes below it. i have tried giving z-index, but nothing works fine can any body suggest me what to do?
View 2 Replies
View Related
Jan 14, 2010
I have noticed a few requests lately on the forum where there is a request for a dynamic dropdown list (<select...> tag) that would display one set of options if one condition is met, but a different set of options if a different condition is chosen. This is my attempt to solve this problem for other users. The following code is a template to show one way of how this question could be resolved.
[Code]...
View 1 Replies
View Related
May 16, 2010
I need to be able to change the fields of a form based on a drop-down list. Like if someone picks option A field 1 shows and if they change it to option B field 1 and 2 show up without reloading the page.
If you need me to explain more I will try to do a better job. If I could be pointed in the general direction that would be great, I dont exactly need to be spoon-fed, although I do like spoons if you catch my drift .
View 2 Replies
View Related
Jul 13, 2011
I have been struggling on a bit of code for a while now. I need to populate a second drop down list (Region) based upon the selection of the first (County).I have found a piece of code that works on its own and have adapted to suit my needs - see below. However, when I drop it into my main page the javascript is not working. It's because of the formObject but I just don't know enough to resolve this! Furthermore, I need the textboxes the user has already completed in the form to retain their value once the javascript kicks in as the completed form will submit to a database.This piece of code is working well . . . .
<?php
$link = mysql_connect('myhost', 'myusername', 'mypassword') or die('Could not connect: ' . mysql_error());
mysql_select_db('mydatabase') or die('Could not select database');[code]......
View 2 Replies
View Related
Feb 13, 2009
I am working on a registration form. I need to create a dynamic drop down list which will show a certain column when a condition is selected. Example below:- [URL] I have searched everywhere but could find an exact example. I only know I might need java script for this function.
View 4 Replies
View Related
Oct 20, 2009
I'm a complete rooking at javascript (and haven't looked at php in months), but am wondering if its possible to do the following with javascript. I have a listing of 10 to 16 teams. I'd like to be able to list the teams in a drop down select box. And when the user selects a team, that teams listing of players is than shown below. The user should than be able to toggle through the listing to review each time.
View 6 Replies
View Related
Oct 7, 2009
i am currently working on aptana studio nokia wrt plugin to develop a mobile widget where i need to retrieve data from database. i've created a java servlet in eclipse to connect and execute query to the ms sql server 2005 database. in aptana, i am using js file and html file, i'm able to connect to the servlet to retrieve and process the data (split the data) into an array and display the retrieved value (array) on screen. but now i need to put the retrieved value (array) into a drop down list for selection, how could i do that?
for the drop down list, i cannot define the list, it need to be able to read from the servlet as the database is updated, it need to reflect.
View 3 Replies
View Related
Nov 18, 2009
I have a text field, call it income, that when the input is > 0 I need to dynamically show the next text box, and if it is blank hide the next text box. I would like to use onBlur but can't seem to get it to work.
View 5 Replies
View Related
Apr 23, 2011
I want to carry out form validation for drop down lists. My website has 10 drop down lists. I want an alert message to be displayed whenever the user selects a blank field from a drop down list. One of the sample drop down list runs as follows:
[Code]...
How can I include a function that displays an alert message whenever a user selects a blank option from the drop down list?
View 11 Replies
View Related
May 1, 2006
I'd like to know if its possible to shift a select option field into a simple text field based on a check box filled by user.
I have an asp form that carries a few select options. One of them I'd like to permit free editing if the user selects a check box just biside the select option, so enableing free editing by user.
View 2 Replies
View Related
Jan 23, 2010
I'm developing a web page. It includes 2 text boxes. One text box for city and another text box for std code. I wrote the code for auto suggestion to city. Now i want to pre populate the STD code when ever a known city is selected (when city is selected from the recommendations displayed for city field).
View 8 Replies
View Related
Dec 9, 2006
i am trying to display text in which when i selet any option in drop down and click submit. text regarding that gets displayed below that drop down.
i am able to display text but its next page.
View 1 Replies
View Related
Aug 31, 2009
Curious about the following issue. I currently have a dynamic drop-down based on the value of each option.. If selection in top drop-down is B it will show all options with a B contained in the second/resulting drop-down.
Now - I also want to evaluate the options by having the script check for a few keywords..
Example - have it evaluate the drop-down on page load for options with text containing 'blah123' (ex. <option value="0323G">Qwerty - blah123</option>). And if any of the options have that text the script will generate an additional drop-down menu allowing you to select blah123 or other specified text. Say another thing I'd like to search each text string for is 'abump'. If there is 'blah123' and 'abump' contained within the drop-down, a third drop-down menu will be generated (as said before) with only blah123 and abump as options. Whichever of these is selected will narrow down the options available in the final drop-down menu.
View 4 Replies
View Related
Sep 11, 2011
Users enter a page and choose from a drop down list for example when they choose 6 then the page should load 6 text boxes. Im also wondering how we would uniquely name each of the textbox's , Eg textbox 1 would have a name of t_1 and the second would be t_2. hope someone can help me out. Im trying to use javascript with html and php as well in some places.
View 1 Replies
View Related
Jul 28, 2010
I am trying to create a drop down list which depend to the value selected from the previous drop down list. I can add it without problem, but If I change again the value of the first drop down list I would like to remove the previous drop down list generated from the first value. If I try to remove it when I create the element, it even does not create the element, the remove element function seems to work because when you click on the remove link it works.
[Code]...
View 4 Replies
View Related
