here is the code :
saved as createmovie.php per pg 94-95

<?php
//connect to mysql
$connect=mysql_connect("localhost", "root", "*******") or
    die ("Hey man, check your server connection.");

//creating main database
$create=mysql_query("CREATE DATABASE IF NOT EXISTS moviesite")
    or die(mysql_error());

//making sure new database is the active one
mysql_select_db("moviesite");

//creating "movie" table
$movie="CREATE TABLE movie (
     movie_id int(11) NOT NULL auto_increment,
     movie_name varchar(255) NOT NULL,
     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)
)";

$results=mysql_query($movie)
   or die(mysql_error());

//creating "movietype" table
$movietype="CREATE TABLE movietype (
   movietype_id int(11) NOT NULL auto_increment,
   movietype_label varchar(100) NOT NULL,
   PRIMARY KEY (movietype_id)
)";

$results=mysql_query($movietype)
   or die(mysql_error());

//creating "people" table
$people="CREATE TABLE people (
   people_id int(11) NOT NULL auto_increment,
   people_fullname varchar(255) NOT NULL default 0,
   people_isactor tinyint(1) NOT NULL default 0,
   people_isdirector tinyint(1) NOT NULL default 0,
   PRIMARY KEY (people_id)
)";

$results=mysql_query($people)
   or die(mysql_error());

echo "Movie Database successfully created!";
?>


and
moviedata.php per page 95-96:

<?php
//connect msql
$connect=mysql_connect("localhost", "root", "*****")
   or die ("Hey man, check your server connection.");

//choosing right db
mysql_select_db("moviesite");

//inserting data into "movie" table
$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 "movietype" table 19
$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 32
$people="INSERT INTO people (people_id, people_fullname, " .
    "people_isactor, people_isdirector) " .
    "VAULES (1, 'Jim Carrey', 1, 0), " .
    "(2, 'Tom Shadyac', 0, 1), " .
    "(3, 'Lawrence Kasdan', 0, 1), " .
    "(4, 'Keven Kline', 1, 0), " .
    "(5, 'Ron Livingston', 1, 0), " .
    "(6, 'Mike Judge', 0, 1), " .

$results=mysql_query($people)
   or die(mysql_error());

echo "Data inserted successfully!";
?>



the issue is that when irun moviedata.php i get this error:
           Duplicate entry '1' for key 1


i was wondering if anyone knows what the problem could be.

thanks

Have you run moviedata.php before? and if so, did you get an error?
If you had, the part of the data has already been added to the database hence why it's showing an error.

The way around this, is to remove the info that the script added to the database and then run the script again.

yes, i did run it once and got an error...i thought it might be easier to get phpmyadmin installed and running, but after i got it installed and tried running http://localhost/phpmyadmin/index.php i get a 403 error saying that i dont have permission to access it on this server...any ideas on what the issue might be?