Hi,
thanks for the warning, but now, I have another error
Error: 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 'CURDATE(), PRIMARY KEY (MemberID) )' at line 7
$tableSQL = "CREATE TABLE Members
(
MemberID int(11) unsigned NOT NULL auto_increment,
UserName varchar(30) NOT NULL default '',
PassWord varchar(32) NOT NULL default '',
EMail varchar(50),
JoinDate date NOT NULL DEFAULT CURDATE(),
PRIMARY KEY (MemberID)
)";
$sqlquery = "INSERT INTO Members (UserName, PassWord, EMail)
VALUES('$username', '$password', '$email')";
Should I use unsigned for the JoinDate too?
Thanks,
Ervisboy007