Theres gotta be something wrong...

[rwt]

CREATE TABLE users
(
ID INT NOT NULL AUTO_INCREMENT,
Name VARCHAR(15),
LastName VARCHAR(15),
UserPass VARCHAR(32),
Email VARCHAR(40),
ShowEmail BOOL,
IsStaff BOOL,
Specification SET('enviroment, humanitarian, information, developpement'),
Phone VARCHAR(15),
Country VARCHAR(15),
Gender BOOL,
Language VARCHAR(15),
Age DATE,
Comments BLOB,
Method SET('skype, phone, email, aim, yahoo, google, msn, icq, jabber, other'),
JoinDate DATETIME
)

[haroonpk]

Here is ur user table code which will work 100%

CREATE TABLE users
(
ID INT(4) Primary Key NOT NULL AUTO_INCREMENT, Name VARCHAR(15),
LastName VARCHAR(15),
UserPass VARCHAR(32),
Email VARCHAR(40),
ShowEmail BOOL,
IsStaff BOOL,
Specification SET('enviroment', 'humanitarian', 'information', 'developpement'),
Phone VARCHAR(15),
Country VARCHAR(15),
Gender BOOL,
Language VARCHAR(15),
Age DATE,
Comments BLOB,
Method SET('skype', 'phone', 'email', 'aim', 'yahoo', 'google', 'msn', 'icq', 'jabber', 'other'), JoinDate DATETIME
)

[rwt]

oh, so i have to quote every word in a set.
thanks, i get it.