#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 'reset NOT NULL, PRIMARY KEY (`contactid`))' at line 26

[Brian Carlos]

CREATE TABLE `contact` (
`contactid` int(11) NOT NULL auto_increment,
`phone` VARCHAR(255) NOT NULL,
`calltime` ENUM('') NOT NULL,
`whyselling` TEXT NOT NULL,
`current` ENUM('') NOT NULL,
`farbehind` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`name` VARCHAR(255) NOT NULL,
`credit` VARCHAR(255) NOT NULL,
`propertytype` VARCHAR(255) NOT NULL,
`propertylocation` VARCHAR(255) NOT NULL,
`mortgageamount` VARCHAR(255) NOT NULL,
`dateofsale` VARCHAR(255) NOT NULL,
`downpayment` VARCHAR(255) NOT NULL,
`interestrate` VARCHAR(255) NOT NULL,
`saleprice` VARCHAR(255) NOT NULL,
`years` VARCHAR(255) NOT NULL,
`firstmortgage` ENUM('') NOT NULL,
`baloon` ENUM('') NOT NULL,
`baloondue` VARCHAR(255) NOT NULL,
`paymentfrequency` ENUM('') NOT NULL,
`mortgagebalance` VARCHAR(255) NOT NULL,
`hearaboutus` ENUM('') NOT NULL,
`additionalinfo` TEXT NOT NULL,
`reset` reset NOT NULL, PRIMARY KEY (`contactid`)); I need help don't know where the error is can some one give me the corrected code please? Thanks in advance Brian