phpmyadmin A symbol name was expected! (near ")" at position 312)
Solution 1:
As far as I understood from your question, the error rises after the following block:
CREATE TABLE regusers(
UserID INT(11) NOT NULL,
Firstname VARCHAR(50) NOT NULL,
Surname VARCHAR(50) NOT NULL,
Email VARCHAR(50) NOT NULL,
Password CHAR(255) NOT NULL,
DateRegistered DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
)
ENGINE = InnoDB DEFAULT CHARSET = utf8;
The problem is the extra comma after the DateRegistered
column definition.
Also, I would recommend not using Password
as a column name, since it's a reserved keyword.