rendered paste body} else {
?>
<form method="post" action="<?php $_SERVER['PHP_SELF'];?>">
<select name="select_season">
<option value="1">Season 1</option>
<option value="2">Season 2</option>
</select>
<input value="Choose Season" type="submit" />
</form>
<?
$season = $_POST['select_season'];
if ($season = 1) {
$sql = "select * from episode_db where season=1";
} else {
if ($season = 2) {
$sql = "select * from episode_db where season=2";
}
} else {
$sql = "select * from episode_db";
}
$query = mysql_query($sql) or die (mysql_error());
while($row = mysql_fetch_assoc($query)) {
?>