%preserve_order%>
<%insert_title%> : Featured Products
<%include:header%>
$howmany = 50;
$sqlquery = "SELECT link_name, link_hits, inl_links.link_id, cust1, cust7 FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id where link_pick = 1 order by link_hits desc limit $howmany";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
$count = 1;
if ($number < 2) {
return false;
}
else { ?>
| |
Product |
License |
Downloads |
while ($number > $i) {
$id = mysql_result($result,$i,"link_id");
$product = mysql_result($result,$i,"link_name");
$license = mysql_result($result,$i,"cust1");
$downloads = mysql_result($result,$i,"link_hits");
$downloads = number_format($downloads);
$version = mysql_result($result,$i,"cust7");
$fproduct = ereg_replace(' ','_',$product);
$fproduct = ereg_replace('\'','',$fproduct);
$count = $i + 1;
echo "
| $count. |
$product $version |
$license |
$downloads |
";
$i++;
}?>
} ?>
<%include:footer%>