the book is excellent. I was doin great, so I thought. I'm having a problem. The moviedata database was created. However, the only error I get is this one: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), (3, 'Grand Canyon', 2, 1991, 4, 3)' at line 1"

The test environment that I'm using is PHP5 and Mysql 5. I realized that the one on the book is an older version (Mysql 4). Can anyone tell me what syntax to use, so it would work? Thanks!

this is the code:
<?php
//connect to mysql
$connect = mysql_connect('localhost', 'root')
or die ("Check your server connection and try again");

//make sure we are using the right database

mysql_select_db("moviesite");

    $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 moviesite 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) " .
    "VALUE (1, 'Jim Carrey', 1, 0), " .
    "(2, 'Tom Shaday', 0, 1), " .
    "(3, 'Lawrence Kasdan', 0, 1), " .
    "(4, 'Kevin Kline', 0, 1), " .
    "(5, 'Ron macray', 0, 1), " .
    "(6, 'Mike Shaday', 0, 1)";
$results = musql_query($people)
 or die(mysql_error());

echo "Data inserted successfullly!";
?>

First, please understand I am very new to this as well. I had the exact same problem when I was there, If I remember correctly I fixed it by replacing the movie_id numbers with NULL. In the create movie.php file we have movie_id int(11) NOT NULL auto_increment. If this is auto incremented AND we assign a value to the ID it will cause an error. So, we need to assign a NULL value to it and let php assign the values.

I hope this helps you.

It looks like you haven't copied to code correctly. The first mistake is highlighted by your mysql error message.

you wrote :
"(2, 'Office Space', 5, 1999, 5, 6,), "

you needed to write :
"(2, 'Office Space', 5, 1999, 5, 6), "

only 1 little comma (,) after the 6. MySQL is probably showing you have not entered anything after the 6 and in effect added another data set to your list.