$howmany = 25;
$sqlquery = "SELECT link_name, link_desc, link_hits, inl_links.link_id, cust7, cust23, cat_id FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id LEFT JOIN inl_lc ON inl_links.link_id=inl_lc.link_id group by link_name order by link_hits desc limit $howmany";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
if ($number < 2) {
return false;
}
else { ?>
| Product |
|
Downloads |
while ($number > $i) {
$id = mysql_result($result,$i,"link_id");
$pulledcat = mysql_result($result,$i,"cat_id");
$product = mysql_result($result,$i,"link_name");
$desc = mysql_result($result,$i,"link_desc");
$downloads = mysql_result($result,$i,"link_hits");
$downloads = number_format($downloads);
$version = mysql_result($result,$i,"cust7");
$iconurl = mysql_result($result,$i,"cust23");
$fproduct = ereg_replace(' ','-',$product);
$desc = html_substr($desc,70);
echo " | $product $version $desc | $downloads |
";
$i++;
}
?>
} ?>