Having a problem with an ebook store site

Discussion in 'PHP' started by hosters, Dec 27, 2009.

  1. #1
    Having a problem with an ebook store site. In the admin cp the banner managment is not working geting an error.
     
    hosters, Dec 27, 2009 IP
  2. HuggyStudios

    HuggyStudios Well-Known Member

    Messages:
    724
    Likes Received:
    20
    Best Answers:
    26
    Trophy Points:
    165
    #2
    Have you got any more information? What is the error that you are getting?
     
    HuggyStudios, Dec 27, 2009 IP
  3. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #3
    lol exactly. Could you put at least 20 seconds of effort into writing your question. Do you think we can read your mind? You've not given any info whatsoever!
     
    JAY6390, Dec 27, 2009 IP
  4. Brandon_R

    Brandon_R Peon

    Messages:
    330
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    What is the script you are using? Does the author provide support?
     
    Brandon_R, Dec 27, 2009 IP
  5. hosters

    hosters Active Member

    Messages:
    1,181
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    78
    #5
    1064 - 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 '-20, 20' at line 1

    select banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_title, banners_group limit -20, 20
     
    hosters, Dec 27, 2009 IP
  6. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Well there is the problem right there, LIMIT has a lower boundary of 0, yet you have -20. How can you have a limit starting at the -20th record??
     
    JAY6390, Dec 27, 2009 IP
  7. hosters

    hosters Active Member

    Messages:
    1,181
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    78
    #7
    I'm just looking for someone to fix it. I don't know much about the script
     
    hosters, Dec 27, 2009 IP