$howmany = 10; $sqlquery = "SELECT DISTINCT link_name, link_hits, inl_links.link_id, cust7 FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id LEFT JOIN inl_lc ON inl_lc.link_id = inl_links.link_id WHERE inl_lc.link_pend = '0' order by link_hits desc limit $howmany"; $result = mysql_query($sqlquery); $number = mysql_numrows($result); $i = 0; if ($number < 1) { echo " None Found"; } else { ?>
| $mpcount. | $product |