Could someone write me a script?

[bgtking]

What I want to do is display the most viewed topics in a specific forum on my website(Non-vB page). I run a Roller Coaster Tycoon website and I want to be able to display the hottest new parks in construction based on the number of views. Would anyone be kind enough to write a script that does this for me? Thanks.

[filburt1]

Here's the query:
[sql]
SELECT threadid, title FROM thread WHERE forumid = forum id ORDER BY views DESC, dateline DESC, title LIMIT 10;
[/sql]
That gets the threadids and titles of 10 threads ordered by highest views, then most recent posting, then title.

[bgtking]

But what is the code to extract it from the databse for the page?