Adding/removing data to mysql database

Discussion in 'WordPress' started by alex05, Mar 9, 2011.

0
  1. #1
    I've created a menu page inside the wordpress dashboard with a form with only a submit button, when i press the submit button the form have to add/remove data from the mysql database of wordpress

    this is the code of the form

    http://pastie.org/1652253

    When i press the submit button i get this message

    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 'CREATE TABLE IF NOT EXISTS wp_terms ( term_id bigint(20) unsigned NOT ' at line 3

    How do i fix this ? what's wrong
     
    alex05, Mar 9, 2011 IP
  2. adbox

    adbox Well-Known Member

    Messages:
    906
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    155
    Digital Goods:
    1
    #2
    I've looked but can't tell offhand. I've never been good at spot checking SQL. Have you emailed the developer and asked him?
     
    adbox, Mar 10, 2011 IP
  3. Client Management System

    Client Management System Peon

    Messages:
    19
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Shouldn't all queries ( DROP and CREATE ) be separated by a semicolon ?
     
    Client Management System, Mar 10, 2011 IP