"; // newest properties $q1 = "select * from re2_listings, re2_agents, re2_priority where re2_listings.AgentID = re2_agents.AgentID and re2_agents.PriorityLevel = re2_priority.PriorityLevel and re2_agents.AccountStatus = 'active' order by DateAdded desc limit 0,9 "; $r1 = mysql_query($q1) or die(mysql_error()); $lrows = mysql_num_rows($r1); if($lrows > '0') { $ListingTable .= "\n"; while($a1 = mysql_fetch_array($r1)) { $ListingTable .= "\n\t"; if($a1[PriorityLevel] > '1') { $sub = "^{$a1[PriorityLevel]}"; } else { $sub = ""; } $ListingTable .= "\n\t\n\t"; $ListingTable .= "\n\t"; $ListingTable .= "\n\t\n"; $ListingTable .= "\n"; } $ListingTable .= "

"; if(!empty($a1[image])) { $ListingTable .= ""; } $ListingTable .= "

$a1[city], $a1[state], $a1[address] $sub

$a1[rooms] br, $a1[bathrooms] ba"; $MyPrice = number_format($a1[Price], 2, ".", ","); $ListingTable .= "

$$MyPrice

"; } /////////////////////////////////////////////////////////// ///////////// top 10 /////////////////////////////////////////////////////////// $q1 = "select * from re2_listings, re2_agents, re2_priority where re2_listings.AgentID = re2_agents.AgentID and re2_agents.PriorityLevel = re2_priority.PriorityLevel and re2_agents.AccountStatus = 'active' order by visits desc limit 0,9 "; $r1 = mysql_query($q1) or die(mysql_error()); $lrows = mysql_num_rows($r1); if($lrows > '0') { $TopTable .= "\n"; while($a1 = mysql_fetch_array($r1)) { $TopTable .= "\n\t"; if($a1[PriorityLevel] > '1') { $sub = "^{$a1[PriorityName]}"; } else { $sub = ""; } $TopTable .= "\n\t\n\t"; $TopTable .= "\n\t"; $TopTable .= "\n\t\n"; $TopTable .= "\n"; } $TopTable .= "

"; if(!empty($a1[image])) { $TopTable .= ""; } $TopTable .= "

$a1[city], $a1[state], $a1[address] $sub

$a1[rooms] br, $a1[bathrooms] ba"; $MyPrice = number_format($a1[Price], 2, ".", ","); $TopTable .= "

$$MyPrice

"; } require_once("templates/IndexTemplate.php"); echo "
"; require_once("templates/FooterTemplate.php"); ?>