[SOLVED] Modify contents of drop down list

This topic is locked

[SOLVED] Â Modify contents of drop down list	10/22/2006 9:04:30 AM
PHPRunner General questions
R runey author I'm assuming I ned to put something in the WHERE box in the lookup wizard, but I'm not sure what... What I'm trying to achieve... User selects a continent from a drop down list... The next drop down list is a list of countires... I only want to show countries that are in the selected continent... The next drop down list is a list of states/provences... Same deal, I only want to show states that are in the selected country... I believe I have the required fields in the tables... e.g. Countries table contains country_id, country_name and continent_id... State tabe contains state_id, state_name and country_id... Also if it's not pushing the friendship too far... Is it possible to disable drop down lists until the user has selected a value in a previous one... e.g. Can't select a country until they have selected a continent? Thanks heaps in advance

Mark as Solved Mark as not solved

2 replies


J	Jane 10/23/2006
	Hi, you can do it using dependent (linked) dropdown boxes. For more info please have a look at this article: http://www.xlinesoft.com/phprunner/docs/lookup_wizard.htm Also you can see "How to setup dependent dropdown boxes on Edit/Add pages" flash tutorial here: http://www.xlinesoft.com/phprunner/php-database.htm


R	runey author 10/23/2006
	I can't believe I overlooked that <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12025&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' /> I was sure that I needed to add something into the WHERE statement that I didn't even notice the solution directly below it <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12025&image=2&table=forumreplies' class='bbc_emoticon' alt=':o' /> Thanks Jane... Hi, you can do it using dependent (linked) dropdown boxes. For more info please have a look at this article: http://www.xlinesoft.com/phprunner/docs/lookup_wizard.htm Also you can see "How to setup dependent dropdown boxes on Edit/Add pages" flash tutorial here: http://www.xlinesoft.com/phprunner/php-database.htm

2 replies

Mark as Solved Reply