[DrP]

I'm getting this error "Duplicate entry '1' for key 1" with the following PHP. What on earth does it mean? I've looked for duplicate entries but I can't see any. When I look ate the database contents in phpMyAdmin the movietype and people tables are empty.

//insert data into the movie table
$insert="INSERT INTO movie (movie_id,movie_name,movie_type,movie_year,movie_leadactor,movie_director)" .
"VALUES (1,'Heat',7,1995,1,3)," .
"(2,'The Godfather',7,1972,2,4)," .
"(3,'The Godfather: Part II',7,1974,2,4)," .
"(4,'The Godfather: Part III',7,1990,2,4)," .
"(5,'Scarface',7,1983,2,5)";

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

//insert data into movietype table
$type="INSERT INTO movietype (movietype_id,movietype_label) " .
"VALUES (1,'Sci Fi')," .
"(2, 'Action')," .
"(3, 'Adventure')," .
"(4, 'Documentary')," .
"(5, 'Comedy')," .
"(6, 'Horror')," .
"(7, 'Crime')," .
"(8, 'Kids')";

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

//insert data into people table
$people="INSERT INTO people (people_id,people_fullname,people_isactor,people_isdirector) " .
"VALUES (1,'Al Pacino',1,0)," .
"(2,'Marlon Brando',1,0)," .
"(3,'Michael Mann',0,1)," .
"(4,'Francis Ford Coppola',0,1)," .
"(5,'Brian De Palma',0,1)";

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

echo "Date inserted successfully!";