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? Quote Link to comment 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". Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.