help with mysql

[brentcatoe]

I am trying to run this script to create a table for my login and registration system. Here is the code

CREATE TABLE `users`
( `userid` int(25) NOT NULL auto_increment,
`first_name` varchar(25) NOT NULL default '',
`last_name` varchar(25) NOT NULL default '',
`email_address` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`PASSWORD` varchar(255) NOT NULL default '',
`info` text NOT NULL,
`user_level` enum('0','1','2','3') NOT NULL default '0',
`signup_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`activated` enum('0','1') NOT NULL default '0',
`files_uploaded` int(25) NOT NULL default '0',
`files_uploaded_size` int(25) NOT NULL default '0',
`ip3` varchar(20) NOT NULL default '',
`ip2` varchar(20) NOT NULL default '',
`ip` varchar(20) NOT NULL default ''
primary key ('userid')
)

Where does the problem seem to be, I cannot figure it out. It is probably some stupid mistake because I am half asleep right now but if anyone coudl help I would appreciate it.

Thanks,

 

[TheJeffsta]

Have you tried publishing the page to a server (its serverside code)

 

[NielsJanssen]

Where have you put the code? Cauz the best place to put it would be phpmyadmin.