CREATE TABLE IF NOT EXISTS users (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
username VARCHAR(255) NOT NULL ,
password VARCHAR(255) NOT NULL ,
email TEXT NOT NULL ,
ip VARCHAR(16) NOT NULL ,
group INT(1) NOT NULL DEFAULT 1 ,
banned VARCHAR(5) NOT NULL DEFAULT 'n'
produces this 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 'group INT(1) NOT NULL DEFAULT 1 , banned VARCHAR(5) NOT NULL DEFAULT 'n' at line 7
why? i've used this exact query string in the past, but now it doesn't work?
"Knowledge is power. Abuse it."~Evulness
My portfolio: www.evularts.com