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]