open(); if($conn){ $sqltxt = "select * from racingdefriends order by hitsin desc"; $result = mysql_query($sqltxt); while($rs= mysql_fetch_object($result)) { $tagcatname3 = preg_replace('/\W+/',"-",$rs->sitecat); $tagcatname4 = strtolower(preg_replace('/_$/',"",$tagcatname3)); $caturl = "/link/$tagcatname4.html"; echo "

$rs->sitename : $rs->sitedesc

"; } } $db->close($conn); ?>