In chapter 6 page 164. Creating a new database in phpMyAdmin named chapter6,that part worded fine. But I can not find the chapter6.sql script to populate the db. Maybe I'm missing something. Could someone point me in the right direction. Thanks.

We are looking into this issue and hope to post a resolution soon.

XUMUSKIEFAN
Wrox Moderator

Preferrably sooner than later.

did anyone learn anything about this missing script? i have just hit this page and also don't know this is...

I have been messing about with this one and I think I have the answer.

Ignore the instruction to create a new database called chapter6 and forget about chapter6.mysql.

In the script index.php make the following changes:

Change line 2: $link = mysql_connect("localhost", "root", "")

to: $link = mysql_connect("localhost","root","mysqlpass")

and

line 4: mysql_select_db('chapter6', $link) or die ( mysql_error());

to: mysql_select_db('wiley', $link) or die ( mysql_error());

and away you go! :)

I apologize that this was not posted earlier. Here is the code you need for chater6.mysql:


CREATE TABLE `movie` (
`movie_id` int(11) NOT NULL auto_increment,
`movie_name` varchar(255) NOT NULL default '',
`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`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=4 ;

INSERT INTO `movie` VALUES (1, 'Bruce Almighty', 5, 2003, 1, 2);
INSERT INTO `movie` VALUES (3, 'Grand Canyon', 2, 1991, 4, 3);
INSERT INTO `movie` VALUES (2, 'Office Space', 5, 1999, 5, 6);

CREATE TABLE `movietype` (
`movietype_id` int(11) NOT NULL auto_increment,
`movietype_label` varchar(100) NOT NULL default '',
PRIMARY KEY (`movietype_id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

INSERT INTO `movietype` VALUES (1, 'Sci-Fi');
INSERT INTO `movietype` VALUES (2, 'Drama');
INSERT INTO `movietype` VALUES (3, 'Adventure');
INSERT INTO `movietype` VALUES (4, 'War');
INSERT INTO `movietype` VALUES (5, 'Comedy');
INSERT INTO `movietype` VALUES (6, 'Horror');
INSERT INTO `movietype` VALUES (7, 'Action');
INSERT INTO `movietype` VALUES (8, 'Kids');

CREATE TABLE `people` (
`people_id` int(11) NOT NULL auto_increment,
`people_fullname` varchar(255) NOT NULL default '',
`people_isactor` tinyint(1) NOT NULL default '0',
`people_isdirector` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`people_id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=7 ;

INSERT INTO `people` VALUES (1, 'Jim Carrey', 1, 0);
INSERT INTO `people` VALUES (2, 'Tom Shadyac', 0, 1);
INSERT INTO `people` VALUES (3, 'Lawrence Kasdan', 0, 0);
INSERT INTO `people` VALUES (4, 'Kevin Kline', 1, 0);
INSERT INTO `people` VALUES (5, 'Ron Livingston', 0, 0);
INSERT INTO `people` VALUES (6, 'Mike Judge', 0, 0);

Can anyone help me. I cant figure out how to get my phpadmin program to open. I cant find the shortcut for it.

never mind. i got it figured out.

Robbie