Thanks! I was the one who asked for it... I will try it...
I'm getting this error:
Code:
Invalid SQL:
SELECT COUNT(*) AS count, post.userid, post.username FROM foro_post
LEFT JOIN foro_thread AS t ON(post.threadid = t.threadid)
LEFT JOIN foro_forum AS f ON(f.forumid = t.forumid)
WHERE f.forumid = 3
GROUP BY username
ORDER BY count DESC
LIMIT 5;
MySQL Error : Unknown column 'post.userid' in 'field list'
Error Number : 1054
Date : Saturday, May 10th 2008 @ 02:55:01 AM
Script : http://www.xxxx.com/forumdisplay.php?f=3
Referrer : http://www.xxxx.com/
IP Address : XXX.XX.XX.XX
Username : XXXX
Classname : vB_Database