I solved this. I just had to remove the comma at
//create "reviews" table
$reviews = "CREATE TABLE reviews (
review_movie_id int(11) NOT NULL,
review_date date NOT NULL,
review_name varchar(255) NOT NULL,
review_reviewer_name varchar(255) NOT NULL,
review_comment varchar(255) NOT NULL,
review_rating int(11) NOT NULL default 0,
KEY (review_movie_id)REMOVE COMMA HERE
) TYPE=MyISAM";
|