Pocetnik sam u radu sa bazama i imam problem!!! Pri insertovanju podataka u bazu dobijam error:
Duplicate entry '1' for key 'PRIMARY'
Kod je sledeci:
<?php
//connect to MySQL
$connect = mysql_connect("localhost", "root", "root")
or die ("Hey, check your server connection");
//make sure we’re using the right database
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 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 data into “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', 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!";
?>
Hvala!!!