Query users posts for the month...

[roundhost]

It sortof works :S

Basically, im echoing the results out in a table with the following code:

PHP Code:

echo "<table><tr><td>Username</td><td>Posts</td></tr>";
$result = $DB_site->query("SELECT 
        userid,
        username, 
        COUNT(*) AS totalposts 
FROM 
        post
WHERE 
        DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= dateline
GROUP BY 
        userid
ORDER BY
        totalposts DESC
LIMIT 
        10");

$row = $DB_site->fetch_array($result);

while ($row = mysql_fetch_array($result)) {
echo "<tr><td><a href=\"http://www.youngcoders.com/member$row[userid].html\">$row[username]</td><td>$row[totalposts]</td></tr>";
}
echo "</table>"; 


This is not the final code, its just be testing to see if it works...

Anyway, the results i get, are not the top 10 posters in the last week, they are the top 10 posters ever, and my only super mod, doesnt appear in the results, yet i do, even though im a admin :S

I do not see how that could have happened...