Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
I am trying to write a query that involves points from posts. The points are based on characters from posts, so I would like to divide points by posts to find average points-per-post. The only issue is that I installed the points system a decent few years after the forum started, so I need to count the posts starting from a certain date.
I need the query to count the sum of posts, starting from August 2009. The forum software is IPB(if anyone is familiar with it).
Alright, I'll post the relevant columns and see if anyone can assist me with writing the query.
These columns are from the posts table.
-author_id(this will equal a variable, so it should look like this in the query: WHERE author_id=$member_id)
-post_date (the format looks like this: 1159984164, I imagine there is a set of numbers that equals somewhere in november?)
Actually I think that is all the relevant columns for the query. Somehow it needs to count how many times author_id=$member_id appears in the table, starting AFTER a certain date. I queried the database for the post where i announced the points system and found the date I need to count the posts after, it is: '1251386095'.
Thanks in advance. Hope my topic isn't too intimidating.. :)
For anyone with the same issue, here is the query:
$query_ppp = ("SELECT COUNT(pid) FROM ibf_posts WHERE post_date > 1251386095 AND author_id='" .$userid. "'");