"; $secondquery=mysql_query("SELECT video_ID, video_name, video_season, video_type FROM video where video_year='".$year_code."'", $link); $secondresult=mysql_num_rows($secondquery); for($j=0;$j<$secondresult;$j++){ list($video_ID, $video_name, $video_season, $video_type)=mysql_fetch_row($secondquery); if ($video_type==1){ echo "Finals Video : " . $video_name . ""; }else if ($video_type==2){ echo "Quarter Finals Video : " . $video_name . ""; }else{ echo "Archived Video : " . $video_name . ""; } echo "
"; } echo "

"; } ?>