A Question about wpdb->prepare()

  • asdasdsadsasasd

    (@vantezzen)


    10 years, 9 months ago

    Hello,
    I never used wpdb->prepare or sprintf() before, so I have a question about them:
    When I execute something like that:

    $table_name = $wpdb->prefix . 'mysqlitable';
$wpdb->prepare('INSERT INTO ´%s´( ´name´ , ´num´ ) VALUES ("%s", "%s")', array($table_name, $listname, $number));

    The outcomming Query is:
    INSERT INTO ´'wp_mysqltable'´ (name,num) VALUES ('test', '1');
    But because of the ‘ that was included there, the query is invalid. How do I fix that?

    PS: The backticks in the query are normally in the right direction but thanks to the wordpress forum code they are changed to “< code>” so I had to flick them`

The topic ‘A Question about wpdb->prepare()’ is closed to new replies.