MYSQL Error Please help :)

Discussion in 'MySQL' started by lobriquida, Oct 9, 2009.

0
  1. #1
    Just install a script on a server using MYSQL 5 the script was wrote to run on MYSQL 4...

    Got this error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out) as tout from hl_traffic where listing_id = 2 and date + interval 7 day > no' at line 1

    Any way to fix it to work for MYSQL 5 ?

    Thanks
     
    lobriquida, Oct 9, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Post the mysql query.
     
    mwasif, Oct 10, 2009 IP
  3. phpdoctor22

    phpdoctor22 Peon

    Messages:
    96
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You will need this date + interval 7 day to be set as a variable.
     
    phpdoctor22, Oct 12, 2009 IP