"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?


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

Reply via email to