After writing the two scripts and ran the first one.. I got an error stating that bp6am access denied to moviesite. I've got pass that by adding CREATE while granting privileges to bp6am under the root admin.
mysql.exe -u root -p test
password: ********** (whatever pw you entered back in ch1)
Code:
GRANT CREATE, SELECT, INSERT, UPDATE ON *.*
TO bp6am@localhost
IDENTIFIED BY "bp6ampass";
But now that I ran after making that correction, I get the following error:
Quote:
|
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 ' movie_name VARCHAR(255) NOT NULL, ' at line 2
|
The code is this:
Code:
//create the movie table
$query = 'CREATE TABLE movie (
movie_id INTEGER UNSIGNED NOT NULL, AUTO_INCREMENT,
movie_name VARCHAR(255) NOT NULL,
movie_type TINYINT NOT NULL DEFAULT 0,
movie_year SMALLINT UNSIGNED NOT NULL DEFAULT 0,
movie_leadactor INTEGER UNSIGNED NOT NULL DEFAULT 0,
movie_director INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (movie_id),
KEY movie_type (movie_type, movie_year)
)
ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));
Did I missed something here? your input will be greatly appreciated.
Error running db_ch03-1.php on pg 87
