I have made a neat little hack that logs the username and IP of all views per thread. I save all this information into a table called VIEWLOG.
Now if the number of views is clicked, a popup window appears with a list of everyone who has viewed this thread.

I am further trying to enhance this hack by creating a report which will generate a views to posts ratio.
This information will be used to generate a Hall of Fame and a Hall of Shame screen.

Here is the SQL I am trying to execute:

SELECT username, posts, (SELECT count(*) FROM viewlog WHERE user.username = viewlog.username) AS 'viewcount' FROM user

This same query works in Microsoft SQL Server but does not in MySQL. The problem may simply bet that MySQL is not as powerful and is incapable of executing this query. I just wanted someone elses opinion and/or a different solution to achive the same query results as my knowlegde of MySQL is limited .

Thank you in advance

You can't do sub-select statements in MySQL (yet... but it is planned)

Thats what I thought......

Can anyone help me to come up with an equivalent solution?

SELECT username, posts, (SELECT count(*) FROM viewlog WHERE user.username = viewlog.username) AS 'viewcount' FROM user ORDER BY viewcount

You could try a left join
http://www.webmasterbase.com/article.php/228/1100