sql query: UPDATE

You’ll want to use the database class, if you’re working in your template make sure php is enabled.

Yes, UPDATE works if you use your own PHP. Iain gave you a great hint to get started.

If you still need help, please post your code. I’ll move this down to Dev & Programming for more community developer assistance as well.

Thank you!

Given below is a very rough example that only updates the value of the custom profile field 42 (not showing where the member ID nor other values come from):

global $DB;

$where_clause = "member_id = '" . $id_from_someplace . "'";
$data = array('m_field_id_42' => $myjunk);
$sql = $DB->update_string('exp_member_data', $data, $where_clause);
$DB->query($sql);

Thanks everyone. Got it.