need help with a FAQ query

[Lynne]

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. )

[steven s]

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

[steven s]

EXACTLY!
The rest is up to me.

Lynne, you are too good for this place.

[Lynne]

Something like...

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'

[steven s]

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