static function save_section_alignment($seating_chart_id, $level, $section, $alignment = "left", $sort_order = "asc") { global $wpdb; $level = strtolower($level); $section = strtolower($section); $sql = $wpdb->prepare("insert into " . EVENTS_SEATING_CHART_LEVEL_SECTION_ALIGNMENT_TABLE . " (seating_chart_id, level, section, alignment, sort_order) values (%d,'%s','%s','%s', '%s')", $seating_chart_id, $level, $section, $alignment, $sort_order); $wpdb->query($sql); $transient = seating_chart::get_section_alignment_transient($seating_chart_id, $level, $section); delete_transient($transient); }