Miscellany

<?php    include_once('includes/dvddb.php');		if($_POST['submit']){			$movieTitleYear = $_POST['movie_title_year'];			$movieGenre = $_POST['movie_genre'];			$moviePlot = $_POST['movie_plot'];			$movieRuntime = $_POST['movie_runtime'];			$movieLink = $_POST['movie_url'];			$movieImage = $_POST['movie_cover'];		}				/*$bracketpos = strpos($movieTitleYear, '(');		$movieYear = substr($movieTitleYear,$bracketpos+1,4);		$movieTitle = substr($movieTitleYear,0,$bracketpos-1);			    function quote_smart($value){	    	if (get_magic_quotes_gpc()) {	        	$value = stripslashes($value);	        }	        if (!is_numeric($value)) {	        	$value = "'" . mysql_real_escape_string($value) . "'";	        }	        return $value;    	}    			$submitquery = "INSERT INTO dvd_titles (title_id, title_name, title_year, title_runtime, title_plot, title_link, title_image, title_submitted)";		$submitquery .= "VALUES (NULL, ". quote_smart($movieTitle) .",";		$submitquery .= quote_smart($movieYear).",";		$submitquery .= quote_smart($movieRuntime).",";		$submitquery .= quote_smart($moviePlot).",";		$submitquery .= quote_smart($movieLink).",";		$submitquery .= quote_smart($movieImage).",";		$submitquery .= "NOW())";		$submitresult = mysql_query($submitquery);*/					$count = count($movieGenre);				for($i=0; $i<$count; $i++){						$genrequery = "SELECT genre_title FROM dvd_genres WHERE genre_id = ".$movieGenre[$i]."";			$genreresult = mysql_query($genrequery);						while($fetchgenres = mysql_fetch_array($genreresult)){				$genre_title = $fetchgenres['genre_title'];			}						$lastquery = "SELECT title_id FROM dvd_titles ORDER BY title_id DESC LIMIT 1";			$lastresult = mysql_query($lastquery);					while ($lasttitle = mysql_fetch_array($lastresult)) {				$title_id = $lasttitle['title_id'];			}						$query = "INSERT INTO `dvd_genresdata` (`data_id`, `genre_id`, `genre_title`, `title_id`) VALUES (NULL, \'".$movieGenre[$i]."\', \'".$genre_title."\', \'".$title_id."\')";			$result = mysql_query($query);			echo "Movie Genre: " . $movieGenre[$i] . "<br />";			echo "Movie Title: " . $genre_title . "<br />";			echo "Movie ID: " . $title_id . "<br />";						}				/*if(mysql_affected_rows() >= 1){			echo "done";		}else{			echo "Sorry, the record could not be added!";		}*/		?>