Jump to content

Getting Resource ID#3 In Topic Field Instead Of Topic Using Boolean Full Text


HowdeeDoodee

Recommended Posts

The database has 6 fields, Source, Topic, Subtopic, References, Theswords, and id.

 

I am getting "resource id #3" in every Topic field display when I use this Select statement for Full Text Boolean. If I use a regular Select statement without a Boolean input, the script works fine. Does anyone have any idea what might be going on?

 

Thank you in advance for any replies.

 

$query = "SELECT * FROM `Table2_CordFT` WHERE MATCH(`Topic`, `Subtopic`, `Theswords`) AGAINST ('+$terms[0] +$terms[1] +$terms[2] +$terms[3] +$terms[4] +$terms[5]' IN BOOLEAN MODE) ORDER BY `Lnum` ASC "; 

} 
elseif (($boolean == TRUE) && ($split == "AND")) 
{ 
$query = "SELECT * FROM `Table2_CordFT` WHERE MATCH(`Topic`, `Subtopic`, `Theswords`) AGAINST ('+$terms[0] +$terms[1] +$terms[2] +$terms[3] +$terms[4] +$terms[5]' IN BOOLEAN MODE) ORDER BY `Lnum` ASC"; 
}
else
{ 
$query = "select * from `Table2_CordFT` where " . presentedCode($SeeAlso,$searchtype) . " AND `Source` IN ($NV, $TR, $BT) ORDER BY `Lnum` ASC";
}

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.