Message Posting Summary [message #32696] |
Sat, 15 July 2006 09:43 |
aleman
Messages: 40 Registered: May 2006 Location: Blackpool UK
Karma: 0
|
Member |
|
|
Thanks for all the help with my problems so far.
One thing that I would like to see is a summary of messages posted by month for each year something along the lines of
Jan Feb Mar Apr Jun Jul Aug Sep Oct Nov Dec
2006 500 345 435 400 . . . . . .
2005
2004
2003
.
.
.
.
Two ways of doing it that I can see.
Table with a total posts in the month, current month updated when user posts. Crude Inelegant but simple
Generate it dynamically with a Single SQL Statement. I know that I could probably pull it together using MS SQL TSQL syntax, but I doubt if its compatible with mySQL.
--
Aleman
|
|
|
Re: Message Posting Summary [message #32726 is a reply to message #32696] |
Mon, 17 July 2006 19:22 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
I see that as a case-by-case requirement and no plans to add it into the stock forum. As far as implementing this, if you are using MySQL 5.0 the best way to do it would be a separate table that gets automatically updated by a trigger on the msg table.
FUDforum Core Developer
|
|
|
Re: Message Posting Summary [message #32731 is a reply to message #32726] |
Mon, 17 July 2006 21:11 |
aleman
Messages: 40 Registered: May 2006 Location: Blackpool UK
Karma: 0
|
Member |
|
|
OK I'm probably off to get down and dirty with some SQL code . . . . Never thought my day job would come in handy with this web lark
Unfortunatly my host has had a filer failure, and are in the process of replacing it . . . Going to have to wait for a while
--
Aleman
|
|
|