Quote:
Originally Posted by pradeep
Use bacticks instead of single quotes for field names and table names!

Code: SQL
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