error::

// connect to mysql

$db=mysql_connect('localhost','admin','password') or die('unable to connect');

//create the main database

$query='CREATE DATABASE IF NOT EXISTS moviesite11';

mysql_query($query,$db) or die(mysql_error($db));

mysql_select_db('moviesite',$db) or die(mysql_error($db));

//create movie table

$query='create table movie11

(

mov_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

mov_name VARCHAR(255) NOT NULL,

mov_type TINYINT NOT NULL DEFAULT 0,

mov_year SMALLINT UNSIGNED NOT NULL DEFAULT 0,

mov_leadactor INTEGER UNSIGNED NOT NULL DEFAULT 0,

mov_director INTEGER UNSIGNED NOT NULL DEFAULT 0,

PRIMARY KEY(mov_id),

KEY mov_type(mov_type,mov_year)

)

ENGINE=MyISAM';

mysql_query($query,$db) or die(mysql_error($db));

//create the movietype table

$query='create table movie_type11

(

movtype_id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,

movtype_label VARCHAR(255) NOT NULL,

PRIMARY KEY(movtype_id),

)

ENGINE=MyISAM';

mysql_query($query,$db) or die(mysql_error($db));

//create table people

$query='create table people11

(

people_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

people_name VARCHAR(255) NOT NULL,

people_isactor TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

PRIMARY KEY(people_id),

)

ENGINE=MyISAM';

mysql_query($query,$db) or die(mysql_error($db));

echo 'Movie Database Successfully Created';

why this code is showing error to me?????

Database ban rha hai magar error show kar rha hai

Unknown database 'moviesite'

1 Reply

Know the answer? Post it — somebody with the same question will find it here.