Dance Events DEVELOPMENT List Future Dance Events [ Production Site ]
Event Calendar  |  Feedback  |  Home  |  Login  |  Newsletters  |  Playlists

Entering List Future

Array
(
    [Action] => List Future
    [venue_id] => 22
)

Help and explanations available at Overview.

get_field_labels:Table: event, Cullme: event

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'event' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 37

From get_fields_label Output from Message

Array
(
    [event_id] => ID
    [access_type] => Access Type
    [alcohol] => Alcohol
    [band_id] => Music
    [brochure_url] => Brochure Url
    [caterer_id] => Caterer
    [close_date] => Close Date
    [captain_id] => Captain
    [dance_type] => Dance Type
    [dance_lesson] => Dance Lesson
    [lesson_level] => Lesson Level
    [discounted_cost] => Discounted Cost
    [end_time] => End Time
    [event_capacity] => Event Capacity
    [event_attire] => Event Attire
    [event_date] => Event Date
    [event_details] => Event Details
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_theme] => Event Theme
    [event_state] => Event State
    [event_type] => Event Type
    [event_url] => Event Url
    [food] => Food
    [guest_cost] => Guest Cost
    [instructor_id] => Instructor
    [foodchoice_id] => Foodchoice Id
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [playlist_url] => Playlist Url
    [musiccontract_url] => Musiccontract Url
    [venuecontract_url] => Venuecontract Url
    [floorplan_url] => Floorplan Url
    [start_time] => Start Time
    [table_capacity] => Table Capacity
    [table_count] => Table Count
    [venue_id] => Venue
)

SELECT distinct event_id from foodchoice

FoodForEvent
Array
(
    [0] => 1
    [1] => 100
    [2] => 102
    [3] => 103
    [4] => 104
    [5] => 105
    [6] => 106
    [7] => 110
    [8] => 111
    [9] => 112
    [10] => 113
    [11] => 114
    [12] => 115
    [13] => 116
)

SELECT DISTINCT e.*,v.venue_name FROM event e, venue v WHERE e.venue_id = v.venue_id AND e.event_id > 1 AND e.event_date >= '2026-10-22' AND e.venue_id='22' ORDER BY e.event_date, e.event_name

SELECT count(event_id) from event WHERE event_date >= '2026-10-22'