> > > I've looked at those, but both approaches requires traversing > through > the entire mysql result set to create another array ( could > be memory > intensive if the result set is large...100,000 ? ) > > -James > I agree. That's why I said the mysql group will give you better answers. Really, the best solution is to just get your answer from mysql. I am 100% sure you can forge an SQL query or series of queries that will return the number you want. JM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php