Table statistics
| From: | Daniel Harik | Date: | Sun, 16 Nov 2003 12:14:22 +0000 |
| Subject: | Table statistics | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-169815@lists.php.net to get a copy of this message | ||
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.