// Do we want to save changes?
if (IS_FORM_SENT()) {
foreach (REQUEST_POST('sel') as $id => $value) {
- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_must_register` SET field_required='%s' WHERE id=%s AND field_required != '%s' LIMIT 1",
- array($value, bigintval($id), $value),__FILE__, __LINE__);
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_must_register` SET field_required='%s' WHERE `id`=%s AND field_required != '%s' LIMIT 1",
+ array($value, bigintval($id), $value),__FILE__, __LINE__);
}
LOAD_TEMPLATE('admin_settings_saved', false, getMessage('REGISTER_ADMIN_CHANGES_SAVED'));
}
// Add more data
$content['sw'] = $SW;
- $content['seleciton'] = ADD_SELECTION('yn', $content['field_required'], "sel[".$content['id']."]");
+ $content['selection'] = ADD_SELECTION('yn', $content['field_required'], "sel[".$content['id']."]");
// @TODO Move this HTML code into a template
$OUT .= "<tr>