Missed your original post :-( but at cinema.com we use the following query to get a list of the actor with the most roles:

SELECT Person.Name, Count(Role.RoleID) AS CountOfRoleID
FROM Role INNER JOIN Person ON Role.PersonID = Person.ID
GROUP BY Person.Name
ORDER BY Count(Role.RoleID) DESC;

Gives the following:

Name	CountOfRoleID
Clint Eastwood	41
Sean Connery	34
Dan Hedaya	30
Robert De Niro	30
Frank Welker	27
Samuel L Jackson	25

Maybe you could mangle the SQL to get what your after?

Hope this helps...

  _____  

~ Richard Allsebrook ~
Applications Developer and Webmaster
Easysoft Limited, Thorp Arch Grange, Thorp Arch, Wetherby, LS23 7BA, UK
http://www.easysoft.com <http://www.easysoft.com>  - http://www.cinema.com <http://www.cinema.com> 
"A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila."

  _____  

-----Original Message-----
From: lennin [mailto:lennin@conexion.com]
Sent: Thursday, February 22, 2001 5:43 PM
To: php-db
Cc: lennin
Subject: FW: Re: [PHP-DB] Most Occurring

you mean the "mode".

I'm afraid you'll have to do it by hand. Other databases do have functions
for a couple of statistics measures( though not sure the mode is included),
but MYSQL doesn't.

Lennin Arriola
lennin@conexion.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net