i have read other postings about the same problem and have tried their suggestion however i still got the same problem with the error
Can't find FULLTEXT index matching the column list
with my query
$result = mysql_query ("SELECT title, description FROM search WHERE MATCH (keywords) AGAINST ('%$keywords%')")or die(mysql_error());
i already alter my table and add fulltext index in my database table..
but i doesn't change anything, still getting the error
this is my database query create table..
CREATE TABLE search (
ID tinyint(4) unsigned NOT NULL auto_increment,
title varchar(75) NOT NULL default '',
url varchar(200) NOT NULL default '',
description mediumtext NOT NULL,
keywords mediumtext NOT NULL,
PRIMARY KEY (ID),
FULLTEXT KEY fulltext_index (title,description,keywords)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
hope someone could help me...
