1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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