I keep on getting the error: "Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\moviesite\createmovie.php on line 15"
this is my code:
<?
//Connect to MySQL; note we've used our own parameters- you should use you own for hostname, user, and password
$connect = mysql_connect("127.0.0.1", "root") or
die("Hey loser, check your server connection.");
//Make sure our recently created database is the active one
mysql_select_db("wiley")
//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)
) TYPE=MyISAM AUTO_INCREMENT=4";
$results = mysql_query($movietype)
or die(mysql_error());
//Create "movietype" table
$movietype= "CREATE TABLE people (
movietype_id int(11) NOT NULL auto_increment,
movietype_label varchar(100) NOT NULL,
PRIMARY KEY (movietype_id),
) TYPE=MyISAM AUTO_INCREMENT=9";
$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)
) TYPE=MyISAM AUTO_INCREMENT=7";
$results = mysql_query($people)
or die(mysql_error());
echo "Movie Database successfully created!";
?>
