get_results("SELECT * FROM " . get_option('events_detail_tbl') . " WHERE id =" . $event_id); foreach ($results as $result){ $event_id = $result->id; $event_name = $result->event_name; $event_desc = $result->event_desc; $start_date = $result->start_date; $end_date = $result->end_date; $start_time = $result->start_time; $end_time = $result->end_time; $calendar_category = $_REQUEST['calendar_category']; $linky = home_url().'/?page_id=' . $org_options['event_page_id'] . '®event_action=register&event_id=' . $event_id . '&name_of_event=' . $event_name; $sql = "INSERT INTO " . WP_CALENDAR_TABLE . " SET event_title='" . mysql_escape_string($event_name) . "', event_desc='" . mysql_escape_string($event_desc) . "', event_begin='" . mysql_escape_string($start_date) . "', event_recur='S', event_repeats='0', event_end='" . mysql_escape_string($end_date) . "', event_time='" . mysql_escape_string($start_time) . "', event_author=".$current_user->ID.", event_category=".mysql_escape_string($calendar_category).", event_link='".mysql_escape_string($linky)."'"; } if ($wpdb->query($sql)){?>

#event-id-insert_id;?>">

.