Hi, I am trying to create a two pages that will allow someone to pick an item from a combo box on the first page and then depending on there selection, the second combo box will fill with information on the second page
When I pick from the first combo box it changes to the second page where. The second combo box retrieves the information based on the first selection. When I pick an option from the second combo box I want to pass both the first and second variable to a third page. The problem is when I do this it changes the ??and ?amp;?to % Values in the address bar and the third page doesn抰 work.
Any help on this would be appreciated
First page
<FORM NAME="Type" ACTION="mens-shoes-manufacture.php?Type=" METHOD="get">
<SELECT NAME="SelectType" ONCHANGE="document.Type.submit()">
<OPTION SELECTED>Please Select</OPTION>
<?PHP
$login="XXX";
$pass ="XXX";
$db=mysql_pconnect("localhost",$login,$pass);
mysql_select_db("XXX",$db);
MySQL_select_db($db_name,$db);
$sql="select * ,count(*) from Men_Shoes group by Type having count(*)>1";
$result=MySQL_query($sql,$db) or die("Bad query:".mysql_error());
while($myrow=MySQL_fetch_array($result))
{
$Type=$myrow["Type"];
echo "<OPTION Value='http://www.phpbuilder.com/board/archive/index.php/$Type'>$Type</OPTION>";
}
?>
</SELECT>
</FORM>
Second Page
<FORM NAME='ManuMenu' ACTION='mens-shoes-shoes.php?' METHOD='get' TARGET="Shoes">
<TD ALIGN="LEFT" VALIGN="MIDDLE">
<?PHP echo"<SELECT NAME='SelectType rawurlencode (=$SelectType&)SelectManu' ONCHANGE='document.ManuMenu.submit()' ALIGN='LEFT'>"; ?>
<OPTION VALUE=http://www.phpbuilder.com/board/archive/index.php/"" SELECTED>Please Select</OPTION>
<?PHP
$login="XXX";
$pass ="XXX";
$db=mysql_pconnect("localhost",$login,$pass);
mysql_select_db("XXX",$db);
MySQL_select_db($db_name,$db);
$sql="select DISTINCT Manufacture from Men_Shoes WHERE Type ='$SelectType' ORDER BY Manufacture ASC";
$result=MySQL_query($sql,$db) or die("Bad query:".mysql_error());
while($myrow=MySQL_fetch_array($result))
{
$Manufacture=$myrow["Manufacture"];
echo "<OPTION Value='http://www.phpbuilder.com/board/archive/index.php/$Manufacture'>$Manufacture</OPTION>";
}
?>
</SELECT>
</TD>
When I pick from the first combo box it changes to the second page where. The second combo box retrieves the information based on the first selection. When I pick an option from the second combo box I want to pass both the first and second variable to a third page. The problem is when I do this it changes the ??and ?amp;?to % Values in the address bar and the third page doesn抰 work.
Any help on this would be appreciated
First page
<FORM NAME="Type" ACTION="mens-shoes-manufacture.php?Type=" METHOD="get">
<SELECT NAME="SelectType" ONCHANGE="document.Type.submit()">
<OPTION SELECTED>Please Select</OPTION>
<?PHP
$login="XXX";
$pass ="XXX";
$db=mysql_pconnect("localhost",$login,$pass);
mysql_select_db("XXX",$db);
MySQL_select_db($db_name,$db);
$sql="select * ,count(*) from Men_Shoes group by Type having count(*)>1";
$result=MySQL_query($sql,$db) or die("Bad query:".mysql_error());
while($myrow=MySQL_fetch_array($result))
{
$Type=$myrow["Type"];
echo "<OPTION Value='http://www.phpbuilder.com/board/archive/index.php/$Type'>$Type</OPTION>";
}
?>
</SELECT>
</FORM>
Second Page
<FORM NAME='ManuMenu' ACTION='mens-shoes-shoes.php?' METHOD='get' TARGET="Shoes">
<TD ALIGN="LEFT" VALIGN="MIDDLE">
<?PHP echo"<SELECT NAME='SelectType rawurlencode (=$SelectType&)SelectManu' ONCHANGE='document.ManuMenu.submit()' ALIGN='LEFT'>"; ?>
<OPTION VALUE=http://www.phpbuilder.com/board/archive/index.php/"" SELECTED>Please Select</OPTION>
<?PHP
$login="XXX";
$pass ="XXX";
$db=mysql_pconnect("localhost",$login,$pass);
mysql_select_db("XXX",$db);
MySQL_select_db($db_name,$db);
$sql="select DISTINCT Manufacture from Men_Shoes WHERE Type ='$SelectType' ORDER BY Manufacture ASC";
$result=MySQL_query($sql,$db) or die("Bad query:".mysql_error());
while($myrow=MySQL_fetch_array($result))
{
$Manufacture=$myrow["Manufacture"];
echo "<OPTION Value='http://www.phpbuilder.com/board/archive/index.php/$Manufacture'>$Manufacture</OPTION>";
}
?>
</SELECT>
</TD>