what is wrong with this wordpress update query?

Question

all

I am using wordpress update query function.

my code is

if($_GET['action'] == 'on')
{
  $form_id = $_GET['form'];
  $entry_id = $_GET['id'];
  global $wpdb;
  $wpdb->query(
  "
  UPDATE $wpdb->wp_frm_items 
  SET alerts = 1
  WHERE id = $entry_id     
  "
  );
}

So what i want to do is if i get action as on then i want to update wp_frm_items table alerts field as 1 which row id is $entry_id . This is not working for me, what is wrong here ?

there no problem with the script i think it updated table did you check it — mgraph, Mar 07 '12 at 10:36

score 2 · Accepted Answer · answered Mar 07 '12 at 10:59

2

This works

$wpdb->query( $wpdb->prepare("UPDATE wp_frm_items SET alerts = 1 WHERE id = $entry_id" ));

answered Mar 07 '12 at 10:59

Ajay Patel

5,298
11
55
87

score 0 · Answer 2 · edited May 23 '17 at 12:05

0

(source:Wordpress update mysql table )

Example:

change user's Nicename and ID

$execut= $GLOBALS['wpdb']->query( $wpdb->prepare( "UPDATE $wpdb->users SET user_nicename = %d WHERE ID = %s",        "Sample_Nicename ", 546 ) );
var_dump($execut);

Learn more at: http://codex.wordpress.org/Class_Reference/wpdb#Examples

edited May 23 '17 at 12:05

Community

1
1

answered Jun 13 '15 at 17:20

T.Todua

53,146
19
236
237

what is wrong with this wordpress update query?

2 Answers2