$link = mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error()); mysql_select_db('wiley', $link) or die ( mysql_error()); $peoplesql = "SELECT * FROM `people` "; $result = mysql_query($peoplesql) or die("Invalid query: " . mysql_error()); while( $row = mysql_fetch_array( $result , MYSQL_ASSOC )){ $people[ $row['people_id'] ] = $row['people_fullname']; } switch( $_GET['action'] ){ case "edit": $moviesql = "SELECT * FROM `movie` WHERE `movie`.`movie_id` = '".$_GET['id']."' "; $result = mysql_query($moviesql) or die("Invalid query: " . mysql_error()); $row = mysql_fetch_array( $result , MYSQL_ASSOC ); $movie_name = $row[ 'movie_name' ]; $movie_type = $row[ 'movie_type' ]; $movie_year = $row[ 'movie_year' ]; $movie_leadactor = $row[ 'movie_leadactor' ]; $movie_director = $row[ 'movie_director' ]; break; default: $movie_name = ""; $movie_type = ""; $movie_year = ""; $movie_leadactor = ""; $movie_director = ""; break; } ?>