Can anyone help with this one?


MySQL said: You have an error in your SQL syntax near 'user(username VARCHAR(20) NOT NULL ,password VARCHAR(20) NULL ,expirydate DATE' at line 1.

Query: CREATE TABLE user(username VARCHAR(20) NOT NULL ,password VARCHAR(20) NULL ,expirydate DATE NULL ,timein VARCHAR(20) NULL ,stateid VARCHAR(20) NULL ,activate SMALLINT NULL )

Try changing:

CREATE TABLE user(

to

CREATE TABLE user (

I am actually creating the table and fields manually through the MySQL html page. When I select the "create table" hypertext and define the number of fields, I am presented with the form to define my fields further. I had no trouble creating my recovery & register tables this way. Is there another method you would suggest to create new tables?

BTW, My DB purpose is for the SQLQuickRegister script, and I am following the documentation for configuring the script located at:

http://www.bytesinteractive.com/...uickregister1.0_doc/

I ran a query and it worked. Not certain why I couldn't do it through the form interface.