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.

Whats wrong with this query?

Discussion in 'Databases' started by maney, Nov 18, 2006.

  1. #1
    I'm installing a phpld mod and it gave me this query to put in phpmyadmin isn't having any of it. I'm using sql5, any ideas what the problem is?

    NSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_THREE_WAY', '0');
    INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('THREE_WAY_LINK_URL', 'http://www.third-site.com/');
    INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('THREE_WAY_LINK_TITLE', 'Third-Site');
    Code (markup):

     
    maney, Nov 18, 2006 IP
  2. fatmagoo

    fatmagoo Peon

    Messages:
    62
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Assuming the fact that the first "INSERT" is missing an "I" is a copy/paste error, what exactly is the error message?
     
    fatmagoo, Nov 18, 2006 IP
  3. Wyla

    Wyla Well-Known Member

    Messages:
    924
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #3
    Also, if your database is already popluated, export some rows and copy their form, changing the values as needed.
     
    Wyla, Nov 18, 2006 IP
  4. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #4
    try this - remove the ` characters.

    i.e. change this
    INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_THREE_WAY', '0');
    Code (markup):
    to this

    INSERT INTO PLD_CONFIG (ID, VALUE) VALUES ('ENABLE_THREE_WAY', '0');
    Code (markup):
     
    daboss, Nov 18, 2006 IP
  5. max pain

    max pain Notable Member

    Messages:
    2,179
    Likes Received:
    521
    Best Answers:
    0
    Trophy Points:
    260
    #5
    PLD_CONFIG is the default configuration table, if you are using other prefix than "PLD_" you should change it in your query to adjust it accordingly.

    Also I hope you are not missing the "i" as fatmagoo has mentioned ;)
     
    max pain, Nov 19, 2006 IP
    jaree likes this.
  6. maney

    maney Active Member

    Messages:
    1,130
    Likes Received:
    36
    Best Answers:
    0
    Trophy Points:
    90
    #6
    Managed to get it working by doing each query line seperatly :)
     
    maney, Nov 19, 2006 IP