nie umiem znaleść powodu tego prosze o pomoc
skrypt wstawiania do bazy:
<?php $insert = "INSERT INTO movie (movie_id, movie_name, movie_type, " , "movie_year, movie_leadactor, movie_director) " , "VALUES(1, 'Bruce Wrzechmogący',5,2003,1,2), " , "(2,'Życie Biurowe',5,1999,5,6), " , "(3,'Wielki Kanion', 2,1991,4,3)"; $type = "INSERT INTO movietype (movietype_id, movietype_label) ", "VALUES (1,'Sc-fi'), " , "(2, 'Dramat'), " , "(3, 'Przygoda'), " , "(4, 'Wojenny'), " , "(5, 'Komedia'), " , "(6, 'Horro'), " , "(7, 'Akcja'), " , "(8, 'Dla dziecie')"; $people = "INSERT INTO people (people_id, people_fullname, " , "people_isactor, people_isdirector) ", "VALUES (1, 'Jim Carey',1,0), " , "(2, 'TOM Shadyac',0,1), " , "(3, 'Lawrence Kasda',0,1), " , "(4, 'Kevin Kline',1,0),", "(5, 'Ron Livigston',1,0),", "(6, 'Mike Judge', 0,1)"; ?>
skrypt którym utworzyłem baze:
<?php $movie = "CREATE TABLE movie ( movie_id int(11) NOT NULL auto_increment, movie_name varchar(255) NOT NULL, movie_type tinyint(2) NOT NULL default 0, movie_year int(4) NOT NULL default 0, movie_leadactor int(11) NOT NULL default 0, movie_director int(11) NOT NULL default 0, PRIMARY KEY (movie_id), KEY movie_type (movie_type,movie_year) )"; $movietype = "CREATE TABLE movietype ( movietype_id int(11) NOT NULL auto_increment, movietype_label varchar(100) NOT NULL, PRIMARY KEY (movietype_id) )"; $people = "CREATE TABLE people ( people_id int(11) NOT NULL auto_increment, people_fullname varchar (255) NOT NULL, people_isactor tinyint(1) NOT NULL default 0, people_isdirector tinyint(1) NOT NULL default 0, PRIMARY KEY (people_id) )"; ?>