'0') { while($a1 = mysql_fetch_array($r1)) { $rArray[] = $a1[0]; } srand ((float) microtime() * 10000000); $MyKey = array_rand($rArray, 1); $DomainID = $rArray[$MyKey]; //get the domain $q2 = "select * from domain_domains where domainid = '$DomainID' "; $r2 = mysql_query($q2) or die(mysql_error()); $a2 = mysql_fetch_array($r2); $ShowDomain = "$a2[domainname]"; $DomainName = $a2[domainname]; //create the select menu $qs = "select * from domain_prices order by PriceValue"; $rs = mysql_query($qs) or die(mysql_error()); $SelectMenu = ""; require_once("templates/header.php"); require_once("templates/IndexTemplate.php"); } else { // no new domains require_once("templates/header.php"); require_once("templates/NoDomains.php"); } require_once("templates/footer.php"); ?>