MySQL query to get total Thread Views?

[cheesegrits]

Ooops, I spaced on the "within a specific number of days" part. As Marco says, the hit data is not timestamped.

As Marco also says, you'd have to log the historic data. A cron job running once a day (or whatever) that pretty much executes the query I gave you, then updates a new table (say 'tothits') with forumid, timestamp and the delta between the current hit value and the previously recorded ones. I think this could be done with a single query, by using an inner SELECT to sum the previously stored deltas for that forum, and subtract it from the current value.

Then your display query would do something like "SELECT SUM(hits) FROM tothits WHERE timestamp > $cutoff", where $cutoff is set to "time() - (60 * 60 * 24 * $numdays)", where $numdays is how far back you want to go.

-- hugh