Not sure if this can be done with just a MYSQL Query or if it needs to be done in conjunction with a PHP script. What I am trying to do is build a dynamic FAQ section with PHP. Here are the two tables
Topics =========== TopicID TopicTitle TopicDESC FAQS =========== FAQID Question Answer Topic I'm trying to get it to display like this Topic1 Question1 Question2 Question3 Question4 Topic2 Question1 Question2 So each topic would be listed with its set of questions below it. Any help would be appreciated. Mike Walth CinoFusion --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
