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

Entering List Future

Array
(
    [Action] => List Future
    [band_id] => 33
    [venue_id] => 18
)

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-02-24' AND e.band_id='33' AND e.venue_id='18' ORDER BY e.event_date, e.event_name

SELECT count(event_id) from event WHERE event_date >= '2026-02-24'

Howmany: 5

open4registration is [5]

Dance Event Options (available only when logged in)
	:	Register and choose table for this event.
	:	Register guest couple for this event. (You will need to have registered and ensure your guests are in our website Who roster. If they are not, use Add User to add them.)
	:	View or update your table if you have registered
	:	View brochure

Column entries that are links will "drill down" to refine your query. Event name links will display event details.
Query returned 1 entry.

Options	Event Name	Event Date	Venue	Music	Event Type	Event Attire
	St. Patrick's Ball	2026-03-20	Campbell Community Center	DJ Otto Madik	Dinner Dance with Singalong	Theme Casual

Entering spew_footer