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

From get_fields_label Output from Message

Array
(
    [access_type] => Access Type
    [band_id] => Band
    [brochure_url] => Brochure Url
    [register_url] => Register Url
    [captain_id] => Captain Id
    [close_date] => Close Date
    [end_time] => End Time
    [event_date] => Event Date
    [event_details] => Event Details
    [event_id] => Event Id
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_type] => Event Type
    [guest_cost] => Guest Cost
    [hostgroup_id] => Host Group
    [location_id] => Where
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [start_time] => Start Time
)

Sunnyvale Moose 2049	Sunnyvale Moose Event Calendar DEVELOPMENT Show Specific Event Details [ Production Site ] Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

SELECT field_name, short_help from help where table_name = 'event'

Array
(
    [access_type] => Fun
    [band_id] => 1
    [brochure_url] => 
    [register_url] => 
    [captain_id] => 1
    [close_date] => 2026-01-12
    [end_time] => 23:00
    [event_date] => 2026-01-12
    [event_details] => Bingo
    [event_id] => 20260123
    [event_keywords] => 
    [event_name] => Bingo
    [event_type] => Fun
    [guest_cost] => 0
    [hostgroup_id] => 14
    [location_id] => 1
    [member_cost] => 0
    [photo_url] => 
    [start_time] => 18:00
)

SELECT DISTINCT e.*,h.hostgroup_name FROM event e, hostgroup h WHERE e.hostgroup_id = h.hostgroup_id AND 1 = 1 AND event_id = '20260123'

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

From get_fields_label Output from Message

Array
(
    [access_type] => Access Type
    [band_id] => Band
    [brochure_url] => Brochure Url
    [register_url] => Register Url
    [captain_id] => Captain Id
    [close_date] => Close Date
    [end_time] => End Time
    [event_date] => Event Date
    [event_details] => Event Details
    [event_id] => Event Id
    [event_keywords] => Event Keywords
    [event_name] => Event Name
    [event_type] => Event Type
    [guest_cost] => Guest Cost
    [hostgroup_id] => Host Group
    [location_id] => Where
    [member_cost] => Member Cost
    [photo_url] => Photo Url
    [start_time] => Start Time
)

Field explanation available via link in left column field labels.

Entering spew_footer