I have a query that returns a result set like the following:

TOPIC   QUESTION        ANSWER
1       A               B
1       C               D
1       E               F
2       G               H
1       I               J
2       K               L
3       M               N

Presentation-wise in PHP, how would I go about making a table to display
results like (i.e. grouped by topic):

1
        A       B
        C       D
        E       F
        I       J



2
        G       H
        K       L

3
        M       N


I've done this with two queries, the first selecting distinct topics and
then running a subquery on all question/answers pertaining to that topic.  I
was just curious if anybody was handing these situations differently.

Thank you!

-m

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to