52
I have 2 select box's
The first box selects season's from the database and works giving an url like index.php?season=1970-71
The second box gets filled with dates (months) from the season row's and works giving an url like index.php?month=1970-08-15
I need to be able to get an url like index.php?season=1970-71&month=08 is this possible?
[PHP]$query = ("SELECT DISTINCT (season) FROM premiership");
echo" ".$season."";
echo" <form action=\"index.php\" method=\"GET\" name=\"form1\">
<label>Season
<select name=\"season\">";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$selectseason = $row['season'];
echo" <option>".$selectseason."";
echo" </option>";
}
echo" </select>
</label><input type=\"submit\" value=\"Submit\">
</form>";
if (isset($_GET['season']))
{
$lastseason= $_GET['season'];
}else{
$lastseason=$selectseason;
}
echo" ".$lastseason."";
//-----------------------------------------
$query = ("SELECT DISTINCT (gamedate) FROM premiership WHERE season = '".$lastseason."' ");
echo" <form action=\"index.php\" method=\"GET\" name=\"form2\">
<label>month
<select name=\"month\">";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$selectmonth = $row['gamedate'];
echo" <option>".$selectmonth."";
echo" </option>";
}
echo" </select>
</label><input type=\"submit\" value=\"Submit\">
</form>";[/PHP]
