Link NameHitsLink"; $q = mysql_query("SELECT * from `links`"); while($links = mysql_fetch_array($q)){ $url = $links["link"]; $hits = $links["hits"]; $id = $links["ID"]; if(strlen($url) > 50){ $url = substr($url,0,50)."..."; } print "$url$hitsClick"; } print ""; ?>