$sql = $wpdb->prepare("INSERT INTO {$wpdb->prefix}tbl_admin_settings (
                        SettingName,
                        SettingValue,
                        SettingText
                      ) VALUES (
                        %s,
                        %d,
                        %s
                      )
                      ON DUPLICATE KEY UPDATE
                        SettingName = %s,
                        SettingValue = %d,
                        SettingText = %s
                      ", $SettingName, $SettingValue, $SettingText, $SettingName, $SettingValue, $SettingText); 
  
  if (current_user_can('administrator'))
    $wpdb->show_errors();
  $wpdb->query($sql);
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *