FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » how many messages?
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: how many messages? [message #161991 is a reply to message #161990] Sat, 06 March 2010 17:44 Go to previous messageGo to previous message
rover_scan is currently offline  rover_scan   Russian Federation
Messages: 31
Registered: January 2010
Karma:
Member

While he had done so:

SELECT fud30_users.login AS login FROM `fud30_msg`
INNER JOIN fud30_users
ON fud30_msg.poster_id=fud30_users.id WHERE post_stamp>1257022801 AND post_stamp<1259614801

Request prompts the user for each message in December 2009. Entries are repeated. List of 4000 lines. How to calculate now the number of messages from each user? That is to get a table of two columns: USER-COUNT?
I do not know ... COUNT? How to use it here? Can use EXEL? Smile
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: SQL errors from the API
Next Topic: Trouble implementing XML Aggregation
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 05:30:23 GMT 2024

Total time taken to generate the page: 0.04146 seconds