HOW TO: Loop a simple query with table output

[sigepjedi]

im basically trying to create a page to show my top 10 commenting users with the following query:

$sql = cpg_db_query("SELECT count( * ) AS TOPCOMMENT, msg_author FROM `bw_comments` GROUP BY author_id ORDER BY TOPCOMMENT DESC LIMIT 10 ");

my query is good, but I cant seem to get it to loop and output correctly in html tables in coppermine.
I thought there would be something like this in the forums, but i couldnt locate any such "Top Commenter" code.

Thanks in Advance!!!

[sigepjedi]

Ok, found the topic.. still getting used to the new forums deep categories:

http://forum.coppermine-gallery.net/index.php?topic=8405.0

for this to work, just modify

db_query(

TO

cpg_db_query(