Mates And Dates FAQ DEVELOPMENT Frequently asked questions (and answers!) [ Production Site ]
Event Calendar  |  Feedback  |  Home  |  Login  |  Newsletters  |  Playlists

Array
(
    [Action] => List
    [faq_class] => Info
    [faq_topic] => Event Participation
)

Array
(
)

get_field_labels:Table: faq, Cullme: faq

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'faq' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 16

From get_fields_label Output from Message

Array
(
    [faq_id] => ID
    [faq_class] => Faq Class
    [faq_topic] => Faq Topic
    [faq_category] => Faq Category
    [faq_state] => Faq State
    [faq_type] => Faq Type
    [faq_subcategory] => Faq Subcategory
    [faq_audience] => Faq Audience
    [faq_access] => Faq Access
    [faq_keywords] => Faq Keywords
    [faq_summary] => Faq Summary
    [assignee_id] => Assignee
    [shelf_life] => Shelf Life
    [more_info] => More Info
    [faq_content] => Faq Content
    [last_modified] => Last Modified
)

SELECT DISTINCT f.*,p.full_name FROM faq f, people p WHERE f.assignee_id = p.people_id AND f.faq_class= 'Info' AND f.faq_topic= 'Event Participation' AND faq_access = 'Public' ORDER BY f.faq_id

Entering spew_footer