Re: [PHP] Table statistics

2003-11-16 Thread John W. Holmes
Daniel Harik wrote: 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 f

[PHP] Table statistics

2003-11-16 Thread Daniel Harik
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