prefix . "pickup_my_calendar"; $query = "SELECT id FROM {$table_name} WHERE picked = 1"; $results = $wpdb->get_results( $query ); $where = ""; foreach ($results as $value) { if ( $where != "" ) $where .= " or "; $where .= "event_id = {$value->id}"; } $events = $mcdb->get_results( "SELECT * FROM " . my_calendar_table() . " where " . $where . " ORDER BY event_begin ASC, event_time" ); foreach ($events as $event) { $occur = $mcdb->get_row( "SELECT occur_id FROM " . my_calendar_event_table() . " where occur_event_id = " . $event->event_id ); $time = strtotime($event->event_begin); $w = date("w", $time); $week_name = array("日", "月", "火", "水", "木", "金", "土"); $date = date("Y.m.d", $time) . "($week_name[$w])"; ?>