Best way to do this (sub selects?)
| From: | motorpsychkill | Date: | Fri, 05 Mar 2004 01:47:59 +0000 |
| Subject: | Best way to do this (sub selects?) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-179513@lists.php.net to get a copy of this message | ||
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