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

[HowdeeDoodee]

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";
}