// Nobody clicked a link, so show all the rows. } else { ?>
/* 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)) { ?>