Announcement

Collapse
No announcement yet.

need help with a FAQ query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • steven s
    started a topic need help with a FAQ query

    need help with a FAQ query

    I need help with a query that will pull all FAQs in a selected faqparent.


    For instance,

    SELECT *
    FROM vb_faq
    WHERE faqparent LIKE 'vb_ax_autocross'

    result vb_faq.faqname
    ax_convertibles
    ax_faq2
    ax_faq3


    Then I need to find
    vb_phrase.varname (ax_convertibles)
    vb_phrase.text
    faqtitle (Are convertibles permitted?)
    faqtext (Absolutely! This is one of the...)

    faqtitle (faq2)
    faqtext (faq2)

    faqtitle (faq3)
    faqtext (faq3)

    I'm lost on the join

    Thanks and Happy New Year

  • Lynne
    replied
    Very nice!

    (I used to autocross my M3. The reason I got the M3 instead of a 3 series with modifications is because I was talked into it on a BMW forum when I was trying to decide which to buy. )

    Leave a comment:


  • steven s
    replied
    Lynn,
    Just want to show you what I needed it for.

    http://www.nccbmwcca.org/content.php?252-Autocross-FAQs
    Before it was a separate hardcoded html page.
    Now it pulls from the FAQs making editing much easier

    Leave a comment:


  • steven s
    replied
    EXACTLY!
    The rest is up to me.

    Lynne, you are too good for this place.

    Leave a comment:


  • Lynne
    replied
    Something like...

    Code:
    SELECT phrase.varname, phrase.fieldname, phrase.text
    FROM vb_faq as faq
    JOIN vb_phrase as phrase ON ( faq.faqname = phrase.varname ) 
    WHERE faqparent =  'xxxxxx'

    Leave a comment:

Loading...
Working...
X