FULLTEXT indexing

[phence]

I get this error:
MySQL said: Can't find FULLTEXT index matching the column list

when i try this query:
SELECT * FROM listings WHERE MATCH trading AGAINST $searchValue;

I have indexed each of my fields. Im not sure how to assign a FULLTEXT index.

All input is greatly appreciated!

[gte604j]

first alter the table to add fulltext to whatever columns

alter table listings add fulltext (trading);

then:

SELECT * FROM listings WHERE MATCH (trading) AGAINST ('$searchValue);

jake