'; $table_name = $wpdb->prefix . 'amazon_settings'; // If POST is set, update database entries if ($_POST) { $api_key = $_POST['api_key']; $secret_key = $_POST['secret_key']; $associate_id = $_POST['associate_id']; $country = $_POST['country']; $sql_delete_settings = "DELETE FROM $table_name"; $wpdb->query($sql_delete_settings); if(!$associate_id){ $associate_id = "azscr-20"; } $sql_amazon_settings = "INSERT INTO $table_name (api_key, secret_key, associate_id, country) VALUES ('$api_key', '$secret_key', '$associate_id', '$country')"; $wpdb->query($sql_amazon_settings); } // Building queries for display in input boxes $sql_api_key = "SELECT api_key FROM $table_name"; $sql_secret_key = "SELECT secret_key FROM $table_name"; $sql_associate_id = "SELECT associate_id FROM $table_name"; $sql_country = "SELECT country FROM $table_name"; ?>