rendered paste body} else {
// Load all the row IDs and episode names into $results
$season = $_POST['select_season'];
echo $season;
$all = mysql_query("select * from episode_db") or die (mysql_error());
$season1 = mysql_query("select * from episode_db where season='1'") or die (mysql_error());
$season2 = mysql_query("select * from episode_db where season='2'") or die (mysql_error());
?>
<form method="post" action="<? $_SERVER['PHP_SELF'];?>">
<select name="select_season">
<option>Select Season</option>
<option>Season 1</option>
<option>Season 2</option>
</select>
<input type="submit" />
</form>
<?
if ($season = 'Season 1')
{
$results = $season1;
}
if ($season = 'Season 2')
{
$results = $season2;
}
else {
$results = $all;
}
while ($row = mysql_fetch_assoc($results)) { ?>