Dance Events
DEVELOPMENT

Production Site ]


Entering List Future

Array
(
    [Action] => List Future
)

Help and explanations available at Overview.

Name Date Band Type Sort By

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: 36

From get_fields_label Output from Message

Array
(
    [event_id] => ID
    [access_type] => Access Type
    [alcohol] => Alcohol
    [band_id] => Band
    [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 Id
    [foodchoice_id] => Foodchoice Id
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [playlist_url] => Playlist Url
    [contract_url] => Contract 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] => 200 [1] => 100 )

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

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

Howmany: 5

open4registration is [5]

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

SELECT * from allcal where calendar_date = '2026-04-03'

SELECT * from allcal where calendar_date = '2026-04-03'

SELECT * from allcal where calendar_date = '2026-05-05'

SELECT * from allcal where calendar_date = '2026-05-05'

SELECT * from allcal where calendar_date = '2026-08-07'

SELECT * from allcal where calendar_date = '2026-08-07'

SELECT * from allcal where calendar_date = '2026-10-02'

SELECT * from allcal where calendar_date = '2026-10-02'

SELECT * from allcal where calendar_date = '2026-12-04'

SELECT * from allcal where calendar_date = '2026-12-04'

Event Name Event Date Venue Band
TBD
Fri Apr 3, 2026
Fireside Room
Bob Guiterrez Quartet
TBD
Tue May 5, 2026
Fireside Room
Bob Guiterrez Quartet
TBD
Fri Aug 7, 2026
Fireside Room
Bob Guiterrez Quartet
TBD
Fri Oct 2, 2026
Fireside Room
Bob Guiterrez Quartet
TBD
Fri Dec 4, 2026
Fireside Room
Bob Guiterrez Quartet

Entering spew_footer


Questions, feedback, or website issues; please let us know by filling out the feedback form or emailing Webmaster.
Last Modified: February 16 2026 @ 00:44 PST