Help with Dropdown Menu Javascript
Hi,
I am trying to create a PHP/Javascript dropdown menu that gets its results from a My SQL Table. Basiclly its three dropdown menus, the user selects their reigion in the first one, this then searches the My SQL table and finds the reigons, after the user has selected their reigon the second drop down box displays the Gardens/Shows based upon the first results, the third then shows the dates of that event based upon what Garden/Shows the user picks.
The problem that I am having is the fact that it does not seem to display the data from the table, all of the PHP/ My SQL is fine.
The code for it is as follows:
The code for the update.php:HTML Code:<script language="javascript" src="update.php"></script> <form name="drop_list" action="sucess.php" method="post"><select name="Main" onchange="SelectCat();"> <option value="">Reigon</option></select> <select id="Category" name="Category" onchange="SelectSubCat();"> <option value="">Garden/Show</option></select><select id="SubCat" name="SubCat"> <option value="">When/Where</option></select></form>
The code for sucess.php:PHP Code:<?php
require "Connection.php";
echo "
function fillCategory(){
";
$q1=mysql_query("select * from `group`");
echo mysql_error();
while($nt1=mysql_fetch_array($q1)){
echo "addOption(document.drop_list.Main, '$nt1[group]', '$nt1[group]');";
}
?>
}
function SelectCat(){
removeAllOptions(document.drop_list.Category);
addOption(document.drop_list.Category, "", "Category", "");
<?
$q2=mysql_query("select distinct(`group`) from category");
while($nt2=mysql_fetch_array($q2)){
echo "if(document.drop_list.Main.value == '$nt2[group]'){";
$q3=mysql_query("select category from category where `group`='$nt2[group]'");
while($nt3=mysql_fetch_array($q3)){
echo "addOption(document.drop_list.Category,'$nt3[category]', '$nt3[category]');";
}
echo "}";
}
?>
}
Hope you can help, ThanksPHP Code:function removeAllOptions(selectbox)
{
var i;
for(i=selectbox.options.length-1;i>=0;i--)
{
selectbox.remove(i);
}
}
function addOption(selectbox, value, text )
{
var optn = document.createElement("OPTION");
optn.text = text;
optn.value = value;
selectbox.options.add(optn);
}
[
CSS Codes
Reply With Quote
Bookmarks