What's your average Post length?

[Fuzz]

Ah, what a great query to run!

650 on my board.

I was wondering if you could place a code in the showtread function file (3.0.7) to display the average post length for each user, is this possible?? I thought it would be as simple as adding a WHERE clause to the end of the this original query, but how do you code it so that each postbit will display a different #, and not just the userid amount of the current viewer.

Here Is My Current Incorrect CODE:

PHP Code:

$postlength = $DB_site->query_first("
SELECT SUM(length(pagetext))/count(postid) AS length
FROM post
WHERE userid=$bbuserinfo[userid]"); 


then of course just toss $postlength[length] into the postbit template...

This would be a nifty stat for users, plus it would show who is typing the short posts. Just don't know what I'm doing wrong. Didn't mean to take this topic off course, just thought it was relevant for this thread, as opposed to making a new one.