HowdeeDoodee Posted June 9, 2007 Share Posted June 9, 2007 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"; } Link to comment https://forums.phpfreaks.com/topic/54903-getting-resource-id3-in-topic-field-instead-of-topic-using-boolean-full-text/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.