Announcement

Collapse
No announcement yet.

need help with a FAQ query

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

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


  • 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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X