hi im new to html and php and i made a file that connect to my mysql and i seem to get na error on my line 5 but im unsure of the error. anyone may have an idea?
the exact error i get is "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 'Email varchar(55) NOT NULL, D.O.B varchar(10) NOT NULL, Password varchar(1' at line 5"
mysql_connect('68.178.142.193', 'RootSpread', '*****')
or die (mysql_error());
mysql_select_db('RootSpread')
or die (mysql_error());
mysql_query("create table account(
firstname int(20) NOT NULL,
initial varchar(20) NOT NULL,
lastname varchar(20) NOT NULL
Email varchar(55) NOT NULL,
D.O.B varchar(10) NOT NULL,
Password varchar(18) NOT NULL,
ID int(11) NULL,
PRIMARY KEY (ID)
)") or die (mysql_error());
echo "Complete.";
?>
thanks in advance!