FUDforum: How To » how many messages?

Home » FUDforum » How To » how many messages?

Show: Today's Messages :: Polls :: Message Navigator

Re: how many messages? [message #161991 is a reply to message #161990]

Sat, 06 March 2010 17:44

rover_scan

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

Report message to a moderator

[Message index]

		how many messages? By: rover_scan on Mon, 22 February 2010 09:48
		Re: how many messages? By: naudefj on Mon, 22 February 2010 15:55
		Re: how many messages? By: rover_scan on Mon, 22 February 2010 17:41
		Re: how many messages? By: rover_scan on Fri, 05 March 2010 15:06
		Re: how many messages? By: naudefj on Fri, 05 March 2010 15:52
		Re: how many messages? By: rover_scan on Sat, 06 March 2010 06:52
		Re: how many messages? By: rover_scan on Sat, 06 March 2010 17:44
		Re: how many messages? By: naudefj on Sun, 07 March 2010 09:00
		Re: how many messages? By: rover_scan on Sun, 07 March 2010 11:16

Previous Topic:	SQL errors from the API
Next Topic:	Trouble implementing XML Aggregation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 21:13:04 GMT 2025

Total time taken to generate the page: 0.03998 seconds