All pastes #285644 Raw Edit

Unnamed

public php v1 · immutable
#285644 ·published 2006-12-19 23:13 UTC
rendered paste body
?>		                $selectlastquery = "SELECT title_id FROM dvd_titles ORDER BY title_id DESC LIMIT 1";		$lastqueryresult = mysql_query($selectlastquery);						$count = count($movieGenre);							foreach ($movieGenre as $value) {				$selectgenres = "SELECT genre_titles FROM dvd_genres WHERE genre_id = ".$value."";				$genreresult = mysql_query($selectgenres);								while($genrefetch = mysql_fetch_array($genreresult)){						while($fetchlast = mysql_fetch_array($lastqueryresult)){							   			$submitgen = "INSERT INTO dvd_genresdata (data_id, genre_id, genre_title, title_id)";			   			$submitgen .= "VALUES (NULL, " . $value .",";			   			$submitgen .= $genrefetch[0] . ",";			   			$submitgen .= $fetchlast['title_id'] . ")";					}				}			}?>errors:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwpauli/public_html/projects/dvd/submit_title.php on line 50Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwpauli/public_html/projects/dvd/submit_title.php on line 50Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwpauli/public_html/projects/dvd/submit_title.php on line 50Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwpauli/public_html/projects/dvd/submit_title.php on line 50Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwpauli/public_html/projects/dvd/submit_title.php on line 50Sorry, the record could not be added!