"; echo "TOP TEN

"; $SQL = "SELECT * FROM links ORDER BY clicks DESC LIMIT 0,10"; $result = mysql_query($SQL); $num = mysql_numrows($result); echo ""; echo ""; echo ""; for ($i=0;$i<$num;$i++) { $onelink = mysql_result($result,$i,"onelink"); $link = mysql_result($result,$i,"link"); if (strlen($link) > 33) { $shortlink = substr($link,0,29); $shortlink .= "..."; } else { $shortlink = $link; }; $clicks = mysql_result($result,$i,"clicks"); $lfd = $i+1; echo ""; }; echo "
RangURLIDClicks
$lfd.$shortlink$onelink$clicks
"; echo ""; echo "

more to come..."; echo ""; require("footer.php"); ?>