while($row = $best_selling_rs->FetchRow())
{

	$most_sold_sql = 'select count(itemcode) as total_sold, itemcode from shoppingcart where itemcode = "'.$row['itemcode'].'" group by itemcode';

	$most_sold_rs  = $db->Execute($most_sold_sql);

	$best_selling .= $most_sold_rs->fields['total_sold'].': '.$most_sold_rs->fields['itemcode'].'<br />';

}


// produces the following infoz...
//
// How can i find out which itemcode has the largest number?

30: csg
146: famt
42: nfb0301
68: peg199
75: tosl0502
18: wsb0401
220: dd
27: stug0305