"; echo ""; echo ""; echo "The most beautiful websites in the world"; echo "http://www.cssmix.nl/"; echo "webdesign: Hoogdesign.nl | coding: Tecomaad.nl"; include("includes/connect.php"); $sql = mysql_query("SELECT * FROM site WHERE site_status = '1' AND site_naam != '' ORDER BY site_datum DESC, site_id DESC LIMIT 20"); while($res = mysql_fetch_array($sql)){ echo "\n"; $boem = explode(" ",$res["site_datum"]); $pubdate = date('D, d M Y H:i:s O', mktime($boem[3], $boem[4], $boem[5], $boem[1], $boem[2], $boem[0])); $screen = mysql_fetch_array(mysql_query("SELECT * FROM screen WHERE screen_site = '".$res["site_id"]."'")); $naam = str_replace("_|_",",",$res["site_naam"]); $link = str_replace(" ","-",$res["site_naam"]); echo "\n"; echo "<a href=\"http://www.cssmix.nl/website/".stripslashes($link).".html\" ><img alt=\"\" src=\"http://www.cssmix.nl/screens/thumb".$screen["screen_screen"]."\" border=\"0\" /></a>\n"; echo "".$pubdate."\n"; echo "http://www.cssmix.nl/website/".stripslashes($link).".html\n"; echo "\n"; } echo "\n"; echo "\n"; ?>