Best way to do this (sub selects?)

From: 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

« previous php.general (#179513) next »