Print Page - HOW TO: Loop a simple query with table output

Title: HOW TO: Loop a simple query with table output
Post by: sigepjedi on May 17, 2006, 05:48:27 PM

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

Quote
$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!!!

Title: Re: HOW TO: Loop a simple query with table output
Post by: sigepjedi on May 17, 2006, 06:06:08 PM

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

Quotedb_query(

Quotecpg_db_query(

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: sigepjedi on May 17, 2006, 05:48:27 PM