Jumping Jerry Productions FAQ DEVELOPMENT Frequently asked questions (and answers!) [ Production Site ]
FAQ  |  Feedback  |  Login  |  New Song Suggestions  |  Subscribe

Array
(
    [Action] => List
    [faq_category] => Overview
    [faq_class] => Info
)

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] => Class
    [faq_topic] => Topic
    [faq_category] => Category
    [faq_state] => State
    [faq_type] => Type
    [faq_subcategory] => Subcategory
    [faq_audience] => Audience
    [faq_access] => Access
    [faq_keywords] => Keywords
    [faq_summary] => Summary
    [assignee_id] => Assignee Id
    [shelf_life] => Shelf Life
    [more_info] => More Info
    [faq_content] => 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_category= 'Overview' AND faq_access = 'Public' ORDER BY f.faq_summary