Sql error problem fixer wanted

Discussion in 'Programming' started by bloon, Dec 6, 2008.

  1. #1
    Hi,

    I am trying to import the database, however I've got this problem :

    
    
    Error
    
    SQL query:
    
    INSERT INTO `games` ( `gametitle` , `gamedesc` , `gamefile` , `gameheight` , `gamewidth` , `category` `iconlocation` )
    VALUES (
    'Acne Be Gone', 'Pop as many zits and pimples as you can before the timer hits zero.', '1.swf', 500, 400, 106, '1.png'
    );
    
    MySQL said: Documentation
    #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 '`iconlocation`) VALUES ('Acne Be Gone', 'Pop as many zits and pimples as you can' at line 1 
    
    Code (markup):
    Any expert here how to fix it? Pm me if you can do it for this simple job
     
    bloon, Dec 6, 2008 IP
  2. dreamdx

    dreamdx Member

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    `category` `iconlocation` => `category`, `iconlocation`

    seems like u missed the , ;)
     
    dreamdx, Dec 6, 2008 IP
  3. me4you

    me4you Well-Known Member

    Messages:
    1,989
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    155
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    for sure, lets try now.
     
    me4you, Dec 6, 2008 IP