Help needed with this query

  • wpcares

    (@wpcares)


    10 years, 1 month ago

    Please help me debugging this query.

    I want top update the db but i keep getting an error

    $wpdb->query($wpdb->prepare("UPDATE 'lead_detail' SET value='%d' WHERE field_number='%d'
and lead_id IN (Select b.lead_id from (select * from 'lead_detail') b where b.value='%s' )", $care_id,'61',$care_email );
exit( var_dump( $wpdb->last_query ) );
Viewing 2 replies - 1 through 2 (of 2 total)
  • scotters23

    (@scotters23)

    10 years, 1 month ago

    What’s the error that you get?

    Moderator keesiemeijer

    (@keesiemeijer)

    10 years, 1 month ago

    What’s the error you’re getting?

    You’re missing a round bracket. Try it with this

    $wpdb->query($wpdb->prepare("UPDATE 'lead_detail' SET value='%d' WHERE field_number='%d'
and lead_id IN (Select b.lead_id from (select * from 'lead_detail') b where b.value='%s' )", $care_id,'61',$care_email ));
exit( var_dump( $wpdb->last_query ) );

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Help needed with this query’ is closed to new replies.

Tags