"Richard Davey" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 1. SELECT SUM(IF(boardid='2',1,0)) AS b2, SUM(IF(boardid='1',1,0)) AS b1,
> COUNT(*) AS total FROM thread
>
> 2. SELECT SUM(IF(boardid='2',1,0)) AS b2, SUM(IF(boardid='1',1,0)) AS b1,
> COUNT(*) AS total FROM message
>
> This literally brings back a total number of threads and messages posted
to
> the two respective boards (boardid1 and 2).
> All I am wondering is if this can be combined into a single query or does
> the very nature of using the SUM(IF) not allow this to happen?
Advertising
Your current queries are returning "thread count on
all groups" as a single record and "message count on
all groups" as a single record.
This is a horrible perversion of SQL.
Instead, you want a query which returns a record
with "thread count" and "message count" for each
group.
SELECT
COUNT(DISTINCT threadid) AS threads,
COUNT(*) AS messages
FROM
thread LEFT JOIN message ON message.threadid=thread.id
GROUP BY boardid ASC
WHERE boardid IN ( 1, 2 )
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
