Jump to content

MATCH query issue


Ltj_bukem

Recommended Posts

 

Hi,

 

I am trying to create a search facility that looks through two fields in a table. The table is called song and the two fields are

name, dance.

 

So far I have the following

 


$query = "SELECT name,dance FROM song WHERE MATCH name,dance AGAINST ('$search')";   

 

This query gives no results, but If I search only one field I get a good response, it's when I try two that the problem arises.

 

Cheer

 

Link to comment
https://forums.phpfreaks.com/topic/73320-match-query-issue/
Share on other sites

This seems to work

 


$query = "SELECT dance,name FROM song WHERE MATCH (dance) AGAINST ('$search') OR MATCH (name) AGAINST ('$search')"; 

 

Sometimes the user might type in a 3 letter word such as 'jig'. I know that there are some issues with words with less than 4 characters. I guess I could write some code to add a random letter to any word with 3 letters & hope that the search will pick it up.

 

Thanks

 

 

Link to comment
https://forums.phpfreaks.com/topic/73320-match-query-issue/#findComment-369939
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.