connect_errno) { echo "db connection error : " . $mysql->connect_error; exit(); } $sql = "UPDATE dvd_titles SET ". "title ='" . $_REQUEST["title"] . "' , " . "rating_id=". $_REQUEST["rating"] . " , " . "genre_id=". $_REQUEST["genre"] . " WHERE dvd_title_id =" . $_REQUEST["recordid"]; $results = $mysql->query($sql); if(!$results) { echo "Could NOT save changes."; echo $mysql->error; exit(); } echo "Changes saved!"; ?> Back to search page