' . __('Add New Category', 'event_espresso') . ''; } ?>

query($sql); $sql = "DELETE FROM " . EVENTS_CATEGORY_REL_TABLE . " WHERE cat_id='$del_id'"; $wpdb->query($sql); endwhile; } if ($_REQUEST['action'] == 'delete_category') { //Delete discount data $sql = "DELETE FROM " . EVENTS_CATEGORY_TABLE . " WHERE id='" . $_REQUEST['id'] . "'"; $wpdb->query($sql); $sql = "DELETE FROM " . EVENTS_CATEGORY_REL_TABLE . " WHERE cat_id='" . $_REQUEST['id'] . "'"; $wpdb->query($sql); } ?>

"> users u on u.ID = c.wp_user WHERE c.wp_user = " . $current_user->ID; } $wpdb->query($sql); if ($wpdb->num_rows > 0) { $results = $wpdb->get_results($sql . " ORDER BY c.id ASC"); foreach ($results as $result) { $category_id = $result->id; $category_name = stripslashes($result->category_name); $category_identifier = stripslashes($result->category_identifier); $wp_user = $result->wp_user; ?>
[EVENT_ESPRESSO_CATEGORY event_category_id=""]