Need Help - mysql, html error? not sure.

Discussion in 'HTML & Website Design' started by mighty.one, Sep 3, 2009.

  1. #1
    hi there,

    my programmer has unfortunately gone temporarily awol and hasnt been online for the last couple of days so i need someone's help.

    should be a simple fix for someone that knows how.

    basically, ive got a deals site. i keep getting a mysql error on one of the listings - not sure why.

    also, when i try to imput a "direct link" whilst listing, it doesnt actually keep the link as on the other listings there is a green go to deal button but on some of the listings it doesnt let me save a link - i paste the link in the relevant field, click save and it saves the listing but the link field goes blank.

    The link of the mysql error listing is: h**p://mrbestdeal.com/deal/62/Labtec-Pulse-485-/-PC-Multimedia-Speaker-System-/-28-Watt---only-pound;17.99-@-Play.com

    please substitue the "**" for "tt"

    please let me know if you can help.

    Thanks in advance
     
    mighty.one, Sep 3, 2009 IP
  2. xojac

    xojac Peon

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    When I follow your link I get the same error as you explained but if I go through you lists and click on the product I get:

    h**p://mrbestdeal.com/deal/62/Labtec-Pulse-485--PC-Multimedia-Speaker-System--28-Watt---only-£17.99-@-Play.com

    Notice the 486--PC instead of 486-/-PC to me it seems that is the error, not sure how you generated the url above but with the listing it works fine for me.
     
    xojac, Sep 4, 2009 IP
  3. arbet

    arbet Peon

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Some SQL query is returning an empty result set.
     
    arbet, Sep 4, 2009 IP