What is wronge with my sql script I get an error on line 5..... Please help me. thanx for your time. CREATE TABLE ' edoobc_ user' ( 'id' int (10) unsigned NOT NULL auto_increment, 'username' varchar (20) NOT NULL default '', 'password' varchar (50) NOT NULL default '', 'email' varchar (40) NOT NULL default '', PRIMARY KEY ('id') ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Use bacticks instead of single quotes for field names and table names! Code: CREATE TABLE `edoobc_user` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(20) NOT NULL default '', `password` varchar(50) NOT NULL default '', `email` varchar(40) NOT NULL default '', PRIMARY KEY(`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
NOW IT IS WORKIG!!!!!! I changed it to this: CREATE TABLE edoobc_user ( id int (10) unsigned NOT NULL auto_increment, username varchar (20) NOT NULL default '', password varchar (50) NOT NULL default '', email varchar (40) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1