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

Entering List Photos

Array
(
    [Action] => List Photos
    [event_type] => Dinner Dance with Lesson
)

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.event_type='Dinner Dance with Lesson' ORDER BY e.event_date DESC, 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)
	:	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 4 entries.

Options	Event Name	Event Date	Venue	Music	Event Type	Event Attire
	1940's Winter Ball	2026-01-16	Campbell Community Center	Joe Ferrari Big Band	Dinner Dance with Lesson	Formal
	Farewell To Summer	2025-09-19	MV Masonic Lodge	DJ-Mike	Dinner Dance with Lesson	Casual
	50's Sock Hop	2025-05-16	MV Masonic Lodge	DJ Otto Madik	Dinner Dance with Lesson	Casual
	Black and White Ball	2025-01-10	MV Masonic Lodge	Jerry Vis Band	Dinner Dance with Lesson	Formal

Entering spew_footer