when i go to my "createmovie.php" file from mozilla or internet explorer, i get the following message "Table 'movie' already exists", the code for the createmovie.php is the following:

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

//create the main database if it doesnt already exist
$create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") or
        die(mysql_error());

//activate the newly created database
mysql_select_db("moviesite");

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

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

//create "people" table
$people = "CREATE TABLE people (
    people_id int(11) NOT NULL auto_increment,
    people_fullname varchar(225) NOT NULL,
    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 also when i go to my file moviedata.php, which supplies all the info to populate createmovie.php i get the following message in internet explorer or mozilla: "Duplicate entry '1' for key 1"
The code for moviedata.php is:

<?php

//connect to MySQL

$connect = mysql_connect("localhost", "root", "mypassword")
    or die ("Hey loser, check your server connection.");

//make sure we're using the right database
mysql_select_db("moviesite");

//insert 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, 'Officed 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
$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
$people = "INSERT INTO people (people_id, people_fullname, " .
        "people_isactor, people_isdirector) " .
        "VALUES (1, 'Jim Carey', 1, 0), " .
        "(2, 'Tom Shadyac', 0, 1), " .
        "(3, 'Lawrence Kasdan', 0, 1), " .
        "(4, 'Kevin 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!";

?>


an error that i did find in the code is in a few different instances i had wrote "..or die(mysql_query()); instead of or die(mysql_error());," so i dont know if that messed something up early on, and now i have to "un-do" something..but im not sure, im just following a long in the book "beginning php5, apache, mysql" on page 94.

can anyone please help me figure out why i cant get this to work.
thanks in advance :)

First off, your CREATE TABLE IF NOT EXISTS query never gets executed. You create a string containing that query, but you never execute it. In fact, you then create another query for creating the table without the IF case and then execute that. If you want to keep with this architecture, you should put IF NOT EXISTS in all your CREATE TABLE queries.

However, I do not think you should have CREATE TABLE queries inside a web-accessible PHP page. You should create these pages manually and then have your PHP pages rely on their existence. You should at least move your table creation script into a simple mysqldump-style script, which you would pipe to the mysql executable, rather than needlessly putting it in PHP. In fact, in a highly secured environment, the MySQL user you use from PHP should not have permission to create or drop tables -- only select, insert, update, and delete.

Jon Emerson
http://www.jonemerson.net/