By the way, while I write the message I forgot to correct the
2 dimentional array to array...
Context is everything, :)
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
---
Kim Steinhaug [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
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