i took this straight from Robouk's tutorials
mysql query:
Code:
CREATE TABLE user (
ID smallint(3) NOT NULL auto_increment,
Name varchar(30) NOT NULL default '',
Password varchar(32) NOT NULL default '',
PRIMARY KEY (ID),
UNIQUE KEY Name (Name)
) TYPE=MyISAM;
..entered it into phpmyadmin's sql querries page, and it gave me this error
Code:
Error

SQL-query :  

CREATE TABLE user( ID smallint( 3 ) NOT NULL AUTO_INCREMENT , Name varchar( 30 ) NOT NULL default '', PASSWORD varchar( 32 ) NOT NULL default '', PRIMARY KEY ( ID ) , UNIQUE KEY Name( Name ) ) TYPE = MYISAM 

MySQL said: 


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 'user( ID smallint( 3  )  NOT  NULL  AUTO_INCREMENT , Name varch
Back
can someone help me find the error and set up this table (for user login/registration)

thanks