Berone Posted March 18, 2007 Share Posted March 18, 2007 I have a table with a focus_area and description as a title and post field. I want to be able to search by keyword on these two fields. This table has a primary key 'id' alter table focus_areas add fulltext (focus_area, description); That is what I did to make my full text index. when I do SELECT * FROM focus_areas WHERE MATCH (focus_area, description) AGAINST('$keywords') I can usually only get the results to show from the focus_area and not from the description field. It's like my search is completely ignoring my description. I have tried this many times and can't get the fulltext to work.... Link to comment https://forums.phpfreaks.com/topic/43291-lets-make-a-search/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.