Well, Im about to create some statistics systems myself and havnt really starter thinking of the "optimal" way of doing such calculations so this thread will be much interesting.
I would suggest the following : As you have already pulled out all the data from that month, we need to prosess this. I would create a 2 dimensional array for every Screen_ Name, // Initiate array $count = array(); // Loop through your data and assign all the users like this $count[$Screen_ Name] = 0; This will give you an array of all the users, then you could loop through the data again and add 1 for each instance of the user to meassure the counts : $count[$Screen_ Name]++; Finally you sort the array and print out the first 5. (The 2 last steps should be put together since its no use going through the data twice) -- Kim Steinhaug --------------------------------------------------------------- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --------------------------------------------------------------- "Daniel Harik" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I have table with messages, and i have users table, the are linked via PK > UserID -> UserID, what i need is to select Messages for current month and > calculate top 5 posters list for current month. > > I have create following query but it's not complete: > > SELECT Handle, Screen_Name from MBoard where Message_Date>='2003-11-00' ORDER BY Handle; > > this gets me all messages posted this month ordered by userid > > > Thank You. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
