$SQLCreateTableGames = "CREATE TABLE games (
gameID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
whitePlayer MEDIUMINT NOT NULL,
blackPlayer MEDIUMINT NOT NULL,
gameMessage ENUM('',playerInvited', 'inviteDeclined', 'draw', 'playerResigned', 'checkMate') NULL,
messageFrom ENUM('',black', 'white') NULL,
dateCreated DATETIME NOT NULL,
lastMove DATETIME NOT NULL
);";
I get the following error message:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'playerInvited', 'inviteDeclined', 'draw', 'playerResigned', 'checkMate') NULL, ' at line 5"
I want to know what change should be made,
but keep the way the table works all the same..
It is a chessprogram in PHP.