Can someone help me with this mysql error?

Duplicate entry '1' for key 1

[GoWFB_SEO]

I was reading a example of inserting data to mysql in php script, I tried the following, but it gave me an error message :"Duplicate entry '1' for key 1 "

$connect= mysql_connect("localhost", "testuser", "testpass")or die ("Are you trying to hack me?");
//Create database
$create=mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") or die(mysql_error());
mysql_select_db("moviesite");

//insert data into "movie" table
$insert="INSERT INTO movie (movie_id, movie_name, movie_type, "." movie_year, movie_leadactor, movie_director)"
." VALUES (1, 'Bruce Alm', 5, 2003, 1, 2),"
." (2, 'office space', 2, 1991, 4, 3)";

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

//insert into "movietye" table
$type="INSERT INTO movietype (movietype_id, movietype_label)"
." VALUES (1, 'Sci Fi'),"
." (2, 'Drama'),"
." (3, 'Adve'),"
." (4, 'War'), "
." (5, 'Comedy'),"
." (6, 'Horror'),"
." (7, 'Action'),"
." (8, 'Kids')";
$results=mysql_query($type) or die(mysql_error());

//insert data to people table
$people ="INSERT INTO people (people_id, people_fullname, ". people_isactor, "people_isdirector)" .
" VALUES (1, 'Jim Carrey', 1, 0)," .
" (2, 'Tom Shadyac', 0, 1), " .
" (3, 'Lawrence 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 successfully!";

Can someone clarify it for me? and also, i am not sure why there is a '.' at the end of the line

[gavacho]

Take a look at this line

$people ="INSERT INTO people (people_id, people_fullname, ". people_isactor, "people_isdirector)"

try eliminating the ". and the " before people. The code of this line isn't right. The code would be alot simpler throughout by eliminating most of the "." and merely separating the values by commas.

[GoWFB_SEO]

thanks for your qucik reply, i tried your suggestion, still the same error message.

The problem happens when inserting data into "movie" table. When I delete the following lines:

//insert data into “movie” table
$insert = “INSERT INTO movie (movie_id, movie_name, movie_type, “ .
“movie_year, movie_leadactor, 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());

the code get excuted succesfully.

[FalseDawn]

Make sure you don't already have a row with key "1" in the table you are inserting into!

Key values by definition must be unique for every row.

The periods are for string concatenation, but it's a rather messy way of doing it.