ok this code generates no error but does not create the tables what is wrong?
Please help....
<?php
//db_install.php
include "./common_db.inc";
echo "<html>";
echo "<head></head>";
echo "<body>";
$dbname = "eota_db";
$user_tbl_name = "user";
$user_tbl_def = "usernumber MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,";
$user_tbl_def .= "userid VARCHAR(8) BINARY NOT NULL,";
$user_tbl_def .= "userpassword VARCHAR(20) BINARY NOT NULL,";
$user_tbl_def .= "useremail VARCHAR(50) NOT NULL,";
$user_tbl_def .= "registerdate DATE DEFAULT '0000-00-00' NOT NULL,";
$user_tbl_def .= "lastaccesstime TIMESTAMP(14),";
$user_tbl_def .= "userpriv MEDIUMINT(1) DEFAULT '0' NOT NULL;,";
$user_tbl_def .= "userscore MEDIUMINT(20) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "usergold MEDIUMINT(15) DEFAULT '200' NOT NULL,";
$user_tbl_def .= "catapult MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "mage MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "knight MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "archer MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "cavalry MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "spearman MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "peshouse MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "castle MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "walls MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "tower MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "stable MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "blacksmith MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "arcanesanc MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "alchamistshop MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "mine MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "mill MEDIUMINT(8) DEFAULT '0' NOT NULL,";
$user_tbl_def .= "PRIMARY KEY (userid),";
$user_tbl_def .= "UNIQUE usernumber (usernumber)";
$link_id = db_connect();
if(!$link_id) die(sql_error());
if(!mysql_select_db($dbname)) die(sql_error());
if(!mysql_query("CREATE TABLE $user_tbl_name ($user_tbl_def)"))
die(sql_error());
echo "Successfully created the $user_tbl_name queries.";
echo "<div align=\"center\">";
echo "<a href=\"superuser.php\">Click to finish setup</a></div>";
echo "</body>";
echo "</html>";
?>
