SQL Query

Discussion in 'MySQL' started by Python, May 5, 2007.

0
  1. #1
    Can anyone see whats wrong with this SQL query:


    Im getting this error:


    Any ideas?

    Thanks
     
    Python, May 5, 2007 IP
  2. SoKickIt

    SoKickIt Active Member

    Messages:
    305
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    70
    #2
    SELECT tutorials.title, tutorials.dateadded, tutorials.featured, tutorials.string, tutorials.summary, tutorials.avatarfilename, categories.title AS catname, categories.string AS catstring, users.username, users.ID AS userID,
    MATCH(tutorials.title, tutorials.summary, tutorials.content)
    AGAINST ('$searchterm' IN BOOLEAN MODE) AS score FROM tutorials, categories, users
    WHERE categories.ID = tutorials.categoryID && users.ID = tutorials.authorID && MATCH(tutorials.title, tutorials.summary, tutorials.content)
    AGAINST ('$searchterm' IN BOOLEAN MODE) ORDER BY score DESC
     
    SoKickIt, May 5, 2007 IP
    Python likes this.
  3. Python

    Python Well-Known Member

    Messages:
    680
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    120
    #3
    Perfect :D

    Thanks
     
    Python, May 6, 2007 IP