[PHP] Best way to do this (sub selects?)

2004-03-04 Thread motorpsychkill
I have a query that returns a result set like the following: TOPIC QUESTIONANSWER 1 A B 1 C D 1 E F 2 G H 1 I J 2 K L 3 M N Presentation-wise in

Re: [PHP] Best way to do this (sub selects?)

2004-03-04 Thread Richard Davey
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.

Re: [PHP] Best way to do this (sub selects?)

2004-03-04 Thread joel boonstra
On Fri, Mar 05, 2004 at 01:53:45AM +, Richard Davey 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