Don't really know what's wrong...

[ash992]

Hey guys, before I start I'm new to php and mysql, so apologies if I was just being silly.

mysql_query("CREATE TABLE users(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
Emailadress VARCHAR(30),
Companyname VARCHAR(30),
Password VARCHAR(30),
RegisteredIP INT,
LastvisitedIP INT,
test12 INT,
test INT,)")
or die(mysql_error());  

 

 

There's more put I didn't paste it all, The error I'm getting is,

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 ')' at line 10

 

Line ten is,

Companyname VARCHAR(30),

that line.

 

Can anyone help? :s Thanks in advance.

[Barand]

remove the final comma after "test INT"

 

The line 10 refers to line 10 of the query

[ash992]

Well... Not a clue how I missed that, thank-you good sir! It's working fine.