View Single Post
  #1 (permalink)  
Old August 18th, 2010, 10:59 AM
hozdaman hozdaman is offline
Authorized User
Points: 221, Level: 4
Points: 221, Level: 4 Points: 221, Level: 4 Points: 221, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
Default Chapter 3 using Ready Made Databases

Hi I have been racking my brains trying to figure out whats wrong with my script any help would be appreciated. Thanks.

I am going through pages 94-96

Here is my moviedata script

Code:
//insert data into movie table
$insert = "INSERT INTO movie (movie_id,movie_name,movie_type,
		movie_year,movie_leadacor,movie_director)
		VALUES (1, 'Bruce Almighty', 5,2003,1,2),
		(2,'Office Space',5,1999,5,6),
		(3,'Grand Canyon',2,1991,4,3)";

$results =mysql_query($insert)
	or die(mysql_error());

//insert datat in "movietype" table
$type = "INSERT INTO movietype (movietype_id,movietype_label)
			VALUES (1,'Sci Fi'),
			(2, 'Drama'),
			(3, 'Adventure'),
			(4, 'War'),
			(5, 'Comedy'),
			(6, 'Horror'),
			(7, 'Action'),
			(8, 'Kids')";

$results =mysql_query($type)
	or die(mysql_error());

//insert data into "people" table
$people ="INSERT INTO people (people_id,people_fullname,
			people_isactor,people_isdirector)
			VALUES (1, 'Jim Carrey',0,1),
			(2, 'Tom Shadyac',0,1),
			(3, 'Lawerence Kasdan', 0,1),
			(4, 'Kevin Kline', 1,0),
			(5, 'Ron Livingston', 1,0),
			(6, 'Mike Judge',0,1)";

$results =mysql_query($people)
	or die(mysql_error());

echo "Data inserted succesfully!";
?>
I keep getting the following

Duplicate entry '1' for key 1
Reply With Quote