I have 1 field to update in Mysql database

table -> wp_usermeta

field -> meta_key: _ywpar_user_total_points

field -> meta_value: 4000

The update statement: UPDATE

wp_usermeta` SET `meta_value`= 15 WHERE `user_id`= 1 and `meta_key`="_ywpar_user_total_points"

I've already tried a bunch of code from Wordpress codex and Youtube and others website, like:

global $wpdb;
$wpdb->query
("
    UPDATE $wpdb->wp_usermeta
    SET meta_value = 7000
    WHERE user_id = 1
        AND meta_key = '_ywpar_user_total_points'
");

global $wpdb;
$wpdb->update( 
    'wp_usermeta', 
    array( 
        'meta_value' => 4000,
    ),
    array( 
        'meta_key' => '_ywpar_user_total_points', 'user_id' => 1
    ), 
    array( 
        '%s',   // value1
        '%d'    // value2
    ), 
    array( '%d' ) 
);

none of them are working

php用不了mysql_query语句

Daveth

3个回复