Dynamic Drop-Down Pulling From Database But Option Value Not Working?

Select elements to not inherently change the page location when a new option is selected You can add this functionality - changing the page location to the value of value for the selected option - by adding the following attribute to select : onchange="window.location. Href=this. Options this.selectedIndex.

Value i. E? Php mysql_select_db ("db_name"); echo "Select Your City"; $result = mysql_query ("select DISTINCTROW city_head from database order by city_head"); while ($city_head=mysql_fetch_assoc($database)) { echo "".

$city_headcity_head. "\n"; } echo ".

Elements to not inherently change the page location when a new option is selected. You can add this functionality - changing the page location to the value of value for the selected option - by adding the following attribute to select: onchange="window.location. Href=this.

Options this.selectedIndex. Value" i.e. , Select Your City"; $result = mysql_query ("select DISTINCTROW city_head from database order by city_head"); while ($city_head=mysql_fetch_assoc($database)) { echo "".

$city_headcity_head. "\n"; } echo ""; Note that you must set value appropriately for each city; I don't know your database schema, so I cannot advise you there.

That worked great Cheeken. Thank you! I have a follow-up question.

The drop down list is now linking out, but I'm having trouble getting the URL to be dynamic. In short, each city has its own page ID and I can't seem to get the value to echo unique URLs. Echo "" Any thoughts?

– Steve Jul 29 at 22:04 Is $CityIDPage a variable in the snippet you have there? What value is being assigned to the id with your current implementation, and what value do you want to be assigned to it? This is a 100% guess because I have no idea what your database schema looks like, but perhaps what you want is echo '' .... – cheeken Jul 30 at 9:37 Yes, $CityIDPage is the primary key with a numerical value.So $city_head would include the city name and $CityIDPage would include a unique record number.

What I'm trying to make happen is when you click on $city_head in the drop down menu, it takes you to the unique URL reflected by the record number. E.g. , echo '' I realize this isn't right above, but that's what I'm shooting for.

– Steve Aug 3 at 23:43.

Select elements to not inherently change the page location when a new option is selected.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.