I have a site with a database and a search box that I could type in partial words and it returned results relevant to the letters. This was until I replaced all the data and now it just displays the entire db whenever something is typed into the searchbox, I assume that it is in the DB Structure some where. Trouble is I am not that versed in db structure and was hoping I could possible get some assistance as to where I went wrong. The following is the code to generate the table:
CREATE TABLE `products` (
`ID` int(11) NOT NULL auto_increment,
`prodnum` double default NULL,
`description` varchar(255) default NULL,
`quantity` varchar(255) default NULL,
`genericdescription` varchar(255) default NULL,
`price` decimal(10,2) default NULL,
PRIMARY KEY (`ID`),
FULLTEXT KEY `description` (`description`)
) TYPE=MyISAM AUTO_INCREMENT=3469 ;
THANKS!!!
