Hey Andy,
True, but thats using 5 selects instead of just one, and since we are expecting quite 
a bit of traffic to the site that can add up pretty fast, expecially since we cant 
afford to have a dedicated server but are on a shared hosting package.

If we have no other alternative we will be going with the 5 selects but since there 
seems to be a "join" alternative was hoping someone could help me out.

Thanks anyway.
Cheers,
-Ryan

> Ryan,
> 
> If this query worked, it would return you 5 rows, one for each separate
> count.
> 
> If you execute 5 separate counts in PHP, you'll get 5 separate values with
> the same numbers as above.
> 
> Not radically different?
> 
> Andy


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to