Hilly_2004 Posted March 12, 2006 Share Posted March 12, 2006 Ive got this Full Text Search Select query which works perfectly....[code]SELECT Submissions.Submission_ID , Submissions.Conference_ID , Submissions.Subject_ID , Submissions.Title , Submissions.Summary , Submissions.Keywords , Submissions.Timestamp , forum_members.M_FIRSTNAME , forum_members.M_SURNAME , forum_members.M_NAME , forum_members.MEMBER_ID , MATCH(Submissions.Title , Submissions.Summary , Submissions.Keywords) AGAINST ('$searchstring') AS score FROM Submissions LEFT JOIN forum_members on Submissions.MEMBER_ID = forum_members.MEMBER_ID WHERE Submissions.Conference_ID = $CurrentConfID AND MATCH(Submissions.Title , Submissions.Summary , Submissions.Keywords) AGAINST ('$searchstring') > 0ORDER BY score DESC[/code]It will search the columns title, summary and keywords in a table called Submissions, however at the same time could I search the columns M_FIRSTNAME, M_SURNAME and M_NAME from a table called forum_members? Link to comment https://forums.phpfreaks.com/topic/4759-is-it-possible-to-full-text-search-2-tables-at-the-same-time/ Share on other sites More sharing options...
Hilly_2004 Posted March 12, 2006 Author Share Posted March 12, 2006 I would of thought it would be something like this:[code]SELECT Submissions.Submission_ID , Submissions.Conference_ID , Submissions.Subject_ID , Submissions.Title , Submissions.Summary , Submissions.Keywords , Submissions.Timestamp , forum_members.M_FIRSTNAME , forum_members.M_SURNAME , forum_members.M_NAME , forum_members.MEMBER_ID , MATCH(Submissions.Title , Submissions.Summary , Submissions.Keywords) AGAINST ('$searchstring') AS score FROM Submissions LEFT JOIN forum_members on Submissions.MEMBER_ID = forum_members.MEMBER_ID WHERE Submissions.Conference_ID = $CurrentConfID AND MATCH(Submissions.Title , Submissions.Summary , Submissions.Keywords , forum_members.M_FIRSTNAME , forum_members.M_SURNAME , forum_members.M_NAME , forum_members.MEMBER_ID ) AGAINST ('$searchstring') > 0ORDER BY score DESC[/code]But Im getting an error which says "Wrong arguments to MATCH". Link to comment https://forums.phpfreaks.com/topic/4759-is-it-possible-to-full-text-search-2-tables-at-the-same-time/#findComment-16797 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.