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

Entering List Photos

Array
(
    [Action] => List Photos
)

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-06-24' ORDER BY e.event_date DESC, e.event_name

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

Howmany: 10

open4registration is [10]

Dance Event Options (available only when logged in)
	:	View table seating for events you have attended
	:	View brochure
	:	View photos from that event

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

Options	Event Name	Event Date	Venue	Music	Event Type	Event Attire
	60's Flower Power	2026-05-15	MV Masonic Lodge	DJ TBD	Dinner Dance with Lesson	Theme Casual
	St. Patrick's Ball	2026-03-20	Campbell Community Center	DJ Otto Madik	Dinner Dance with Singalong	Theme Casual
	2026 Annual Membership	2026-01-20	TBD	Band TBD	Annual Membership	Dressy
	1940's Winter Ball	2026-01-16	Campbell Community Center	Joe Ferrari Big Band	Dinner Dance with Lesson	Formal
	Masked Ball	2025-11-21	MV Masonic Lodge	Vintage Jukebox Orchestra	Dinner Dance and Singalong	Formal
	Farewell To Summer	2025-09-19	MV Masonic Lodge	DJ-Mike	Dinner Dance with Lesson	Casual
	Western Theme	2025-07-18	MV Masonic Lodge	DJ-Mike	Dinner Dance with Singalong	Theme Casual
	50's Sock Hop	2025-05-16	MV Masonic Lodge	DJ Otto Madik	Dinner Dance with Lesson	Casual
	St. Patrick's Ball	2025-03-21	MV Masonic Lodge	DJ Otto Madik	Dinner Dance with Singalong	Dressy
	Black and White Ball	2025-01-10	MV Masonic Lodge	Jerry Vis Band	Dinner Dance with Lesson	Formal

Entering spew_footer