Hi,

I received the following message in creating the moviedata file:

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 '. (6, 'Horror'), (7, 'Action'), (8, 'Kids')' at line 1

Here is the excerpted code:

//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());

I had mistakenly put in a period instead of a comma after War and had the error initially. I went back and changed to a comma and still get an error. Where is the error???

Thanks!

Okay, I went back and retyped in a part (the same thing again) and reran the script. This time I received the message that the table is already created error. So I dropped the database altogether and reran both scripts and am fine for now.

In the future you can do this:

b]$clearsql = "TRUNCATE TABLE "tablename"";
$results = mysql_query($clearsql)
or die(mysql_error());[/b]

then run the sql statement - this will clear the table before the right to it.