All pastes #351311 Raw Edit

Someone

public text v1 · immutable
·published 2007-02-12 02:33 UTC
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)) { ?>