Hi There,
I have a select field where i want to update a table field when the value is changed.
So i put this code in the ajax onchange
now the wierd thing is that the value of the select field is not reconized. i tried everything. any suggestions?
// SQL statement parameters
$update_table = ‘ILP_rooster_deelnemer’; // Table name
$update_where = “wk_id = {value_from_select_field}”; // Where clause
$update_fields = array( // Field list, add as many as needed
“wk_status = 4”,
“wk_opm_status = ‘rtr was here’”,
);
// Update record
$update_sql = ‘UPDATE ’ . $update_table
. ’ SET ’ . implode(’, ', $update_fields)
. ’ WHERE ’ . $update_where;
sc_exec_sql($update_sql);