rendered paste body// Nobody clicked a link, so show all the rows.
} else {
?>
<form method="post" action="<?php $_SERVER['PHP_SELF'];?>
<select name="select_season">
<option>Select Season...</option>
<option>Season 1</option>
<option>Season 2</option>
</select>
</form>
<?
/* filters */
$season = $_POST['select_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=1") or die (mysql_error());
if ($season = 'Season 1') {
$results = $season1;
} else {
if ($season = 'Season 2') {
$results = 'Season 2';
} else {
$results = $all;}
}
while ($row = mysql_fetch_assoc($results)) { ?>