I am trying to creat a table, after 2 hours of messing about trying to get phpmyadmin to work I gave up and used the program recommened by my hosting company (fasthosts). This connected in like 2 mins :) but when trying to creat a table, (based of the "Creating a Membership System with PHP and MySQL[url=http://www.phpfreaks.com/tutorials/40/1.php]http://www.phpfreaks.com/tutorials/40/1.php[/url]" on this site) I get the following syntax error [code]An error occurred creating the Table. Server Error: ERROR: 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 ''1' '2' '3') NOT NULL DEFAULT '0', `signup_date` datetime NOT NULL, `last_lo' at line 10 QUERY: CREATE TABLE `Membership_Information` ( `userid` integer (25) NOT NULL auto_increment, `first_name` varchar (25) NOT NULL, `last_name` varchar (25) NOT NULL, `email_address` varchar (25) NOT NULL, `username` varchar (25) NOT NULL, `password` varchar (25) NOT NULL, `info` text NOT NULL, `user_level` enum('0' '1' '2' '3') NOT NULL DEFAULT '0', `signup_date` datetime NOT NULL, `last_login` datetime NOT NULL, `activated` enum('0' '1') NOT NULL DEFAULT '0', `user_image` varchar (50) NOT NULL, `user_country` varchar (50) NOT NULL, PRIMARY KEY (`userid`) ) TYPE=MyISAM [/code] AS far as i can tell when compearing the code to that in the how to gude it looks right, but beeign stuck using [url=http://www.dbtools.com.br/EN/index.php]http://www.dbtools.com.br/EN/index.php[/url] I can not tell if there is something else i am missing out. [url=http://www.thingstodobeforeidie.co.uk/error.jpg]http://www.thingstodobeforeidie.co.uk/error.jpg[/url] screen shot, just incase soem one can see some thing i am missing, thanks in advance.