[ boba.gacas @ 09.02.2010. 11:18 ] @
| 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!!! |