View Single Post
  #1 (permalink)  
Old February 9th, 2009, 06:38 PM
romburak romburak is offline
Registered User
 
Join Date: Mar 2008
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Duplicate entry '1' for key 1

Anybody got this one before?
Duplicate entry '1' for key 1


based on the code from the book p 94-96 I have created the tables:
movie
movietype

it seems I can't create the people table neither to populate the movietype.

Any help?

createmovie.php:

<?
// connect to MySQL
$connect = mysql_connect("localhost", "xxx", "xxx") or
die ("Check your server connection. Sorry");

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

//make sure your recently created database is the active one
mysql_select_db("moviesite");

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

//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(255) 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 succesfully created!";
?>
Reply With Quote