Jump to content

Lets make a search


Berone

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.