whats wrong with this ql??

[krrose27]

ok whats wrong with this?

DROP TABLE IF EXISTS user_reports;

CREATE TABLE user_reports (
 id INT(30) UNSIGNED NOT NULL AUTO_INCREMENT primary key,
 ip varchar(32) NOT NULL,
 ip1 varchar(32) NOT NULL,
 ip2 varchar(32) NOT NULL,
 user varchar(32) NOT NULL,
 user1 varchar(32) NOT NULL,
 user2 varchar(32) NOT NULL,
 user3 varchar(32) NOT NULL,
 email varchar(100) NOT NULL,
 email2 varchar(100) NOT NULL,
 email3 varchar(100) NOT NULL,
 forum varchar(50) NOT NULL,
 link varchar(250) NOT NULL,
 link2 varchar(250) NOT NULL,
 link3 varchar(250) NOT NULL,
 link4 varchar(250) NOT NULL,
 pic varchar(32) NOT NULL,
 pic1 varchar(32) NOT NULL,
 pic2 varchar(32) NOT NULL,
 pic3 varchar(32) NOT NULL,
 pic4 varchar(32) NOT NULL,
 pic5 varchar(32) NOT NULL,
 pic6 varchar(32) NOT NULL,
 message varchar(32) NOT NULL,
 status varchar(32) NOT NULL,
 reportersuser varchar(32) NOT NULL,
);

[bpat1434]

Perhaps the last comma on the "reportersuser" line.....?

[krrose27]

like what? when i run it in sql it says something is wrong with my systanx

[bpat1434]

reportersuser varchar(32) NOT NULL,
); 

Notice how you have a trailing "," after NOT NULL? SQL is looking for another column declaration (which isn't there) so it fails and SQL says there's something wrong with the syntax.