Hello motorpsychkill, Friday, March 5, 2004, 1:47:59 AM, you wrote:
m> I've done this with two queries, the first selecting distinct topics and m> then running a subquery on all question/answers pertaining to that topic. I m> was just curious if anybody was handing these situations differently. You should find that doing a GROUP BY and then ORDER BY on the Topic field gives you the results back in the right sequence for what you want. Your display life in PHP will then be much simpler. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
