When i Try Searching the Listings database i get this error:
Query SELECT * FROM listings WHERE MATCH (trading, wac_1,
wac_2) AGAINST ('test') failed.Can't find FULLTEXT index
matching the column list
This is the Table structure for table 'listings'
CREATE TABLE listings (
id int(11) NOT NULL auto_increment,
trading varchar(50) NOT NULL,
notice varchar(255) NOT NULL,
for_ varchar(50) NOT NULL,
wac_1 varchar(50),
wac_2 varchar(50),
enter_time date,
overdue_time date,
lst_period int(3) DEFAULT '0' NOT NULL,
pos_code int(5) DEFAULT '0',
pic varchar(255),
user_id varchar(15),
PRIMARY KEY (id),
UNIQUE id (id),
KEY trading (trading, wac_1, wac_2)
);
below is the php which queries the mysql database:
// Build a query:
$query = "SELECT * FROM listings WHERE MATCH (trading, wac_1, wac_2) AGAINST ('$searchValue')";
// Run the query. If the query fails, it won't return a result set identifier:
$result = mysql_query($query);
if(!$result) {
echo "Query $query failed.";
// If the query failed, MySQL is usually friendly enough to offer a reason why:
echo mysql_error();
}
Can anyone help me in finding the problem?
All Help Is appreciated! Thank-you!
