Re: Best way to do this (sub selects?)
| From: | Richard Davey | Date: | Fri, 05 Mar 2004 01:53:45 +0000 |
| Subject: | Re: Best way to do this (sub selects?) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-179514@lists.php.net to get a copy of this message | ||
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