Textpattern CMS

#1 2008-11-26 07:16:12

Liiint

Member

From: Tacoma, WA

Registered: 2004-10-01

Posts: 18

Website

Comment Counts

This is a question for the mysql folks out there.

Is there an easy way to output the number of comments per day for the entire database? I’ve looked high and low for a query that will do it for me, but nothing has worked so far. I’m sure it’s easy for someone. What do you suggest?

Thank you.

#2 2008-11-26 12:05:42

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: Comment Counts

Maybe something like:

<txp:php> safe_count('txp_discuss', "posted rlike '2008-10-20' and visible = 1"); </txp:php>

---

Rah | GitHub