mySQL不会创建表

Question

I have it set up to echo when my tables create but the users table just won't, I've looked at multiple solutions but none of them has helped here my code

<? 
    phpinclude_once("index.php");
    $tbl_users = "CREATE TABLE IF NOT EXISTS users 
                  (
                      id INT(11) NOT NULL AUTO_INCREMENT,
                      username VARCHAR(16) NOT NULL,
                      email VARCHAR(64) NOT NULL,
                      password VARCHAR(64) NOT NULL,
                      gender ENUM('m','f') NOT NULL,
                      website VARCHAR(64) NULL,
                      country VARCHAR(64) NULL,
                      userlevel ENUM('a','b','c','d') NOT NULL DEFAULT a,
                      avatar VARCHAR(64) NULL,
                      ip VARCHAR(64) NOT NULL,
                      signup DATETIME NOT NULL,
                      lastlogin DATETIME NOT NULL,
                      notescheck DATETIME NOT NULL,
                      activated ENUM('0','1') NOT NULL DEFAULT 0,
                      PRIMARY KEY (id)),
                      UNIQUE KEY username (username,email))";
    $query = mysqli_query($db_spooky, $tbl_users);

    if ($query === TRUE)
    {
        echo "<h3>user table created OK :) </h3>";
    }
    else 
    {
        echo "<h3>user table NOT created :( </h3>";
    }
?>

Answer 1

CREATE TABLE IF NOT EXISTS users (id INT(11) NOT NULL AUTO_INCREMENT
                                  ,username VARCHAR(16) NOT NULL
                                  ,email VARCHAR(64) NOT NULL,password VARCHAR(64) NOT NULL
                                  ,gender ENUM('m','f') NOT NULL
                                  ,website VARCHAR(64) NULL
                                  ,country VARCHAR(64) NULL
                                  ,userlevel ENUM('a','b','c','d') NOT NULL DEFAULT 'a'
                                  ,avatar VARCHAR(64) NULL
                                  ,ip VARCHAR(64) NOT NULL
                                  ,signup DATETIME NOT NULL
                                  ,lastlogin DATETIME NOT NULL
                                  ,notescheck DATETIME NOT NULL,activated ENUM('0','1') NOT NULL DEFAULT 0
                                  ,PRIMARY KEY (id)
                                  ,UNIQUE KEY username (username,email))

Learn to organize your code instead of writing it in one long line for one, and two, ENUM default for a needs to be in single quotes and you had an extra closing bracket. The code above is the corrected version.