I like to have the top ten from one sub category.
PHPLinks does not seam to have much support so I was wondering if someone here could help me with this easy hack.

Basicly I have a subcategory called 'Dealers'. And I would like to show them on a block sorted by rating.

I have changed the cid=$cid to cid=952

but how do I get rid of the loop?



while(list($cid, $ctitle)=$xoopsDB->fetchRow($result)){

$rankings[$e]['title'] = sprintf(_MD_TOP10, $myts->htmlSpecialChars($ctitle));

$query = "select lid, cid, title, hits, rating, votes from ".$xoopsDB->prefix("addresses_links")." where status>0 and (cid=952";

Thanks

I got it!