Cannot add fields in phpmyadmin

PHP
1

Hi guys, when i try adding a field in phpmyadmin i get this error:

SQL query:

CREATETABLEipbans (

ipaddress VARCHAR( 255)NOTNULL ,
bannedby VARCHAR( 255)NOTNULL
) TYPE= innodb

MySQL said:
#1064 - 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 ‘TYPE = innodb’ at line 1

2

TYPE is not valid, try ENGINE

and please put some spaces into “CREATETABLE” and “NOTNULL”

3

swap the last line for

ENGINE=InnoDB

4

thanks a lot for clearing that up

i guess my reply wasn’t specific enough, eh

:confused: