p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 (http://p2p.wrox.com/forumdisplay.php?f=160)
-   -   Duplicate entry '1' for key 1 (http://p2p.wrox.com/showthread.php?t=72652)

romburak February 9th, 2009 06:38 PM

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!";
?>

romburak February 9th, 2009 06:56 PM

solution
 
Just cleared the old tables and submitted the createmovie.php using the code from the book. Probably stupid spelling error but it run ok this time.


All times are GMT -4. The time now is 01:31 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.