<?
require_once("conn.php");
require_once("includes.php");
require_once("mainsearch.php");
require_once("templates/HeaderTemplate.php");
// ADVANCED SEARCH
//require_once("advanced.php");
//require_once("templates/AdvancedSearchTemplate.php");
echo "<br>";
// 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 .= "<table align=center width=510 border=1 bordercolor=black frame=hsides rules=rows cellspacing=0>\n";
while($a1 = mysql_fetch_array($r1))
{
$ListingTable .= "<tr onMouseOver=\"this.style.background='#E2E2E2'; this.style.cursor='hand'\" onMouseOut=\"this.style.background='white'\" onClick=\"window.open('info.php?id=$a1[ListingID]', '_top')\">\n\t";
if($a1[PriorityLevel] > '1')
{
$sub = "<span class=RedLink><sup>$a1[PriorityLevel]</sup></span>";
}
else
{
$sub = "";
}
$ListingTable .= "\n\t<td width=15>";
if(!empty($a1[image]))
{
$ListingTable .= "<img src=\"myimages/camera.jpg\" width=15 height=15>";
}
$ListingTable .= "</td>\n\t";
$ListingTable .= "<td width=305>$a1[city], $a1[state], $a1[address] $sub</td>\n\t";
$ListingTable .= "<td width=80>$a1[rooms] br, $a1[bathrooms] ba";
$MyPrice = number_format($a1[Price], 2, ".", ",");
$ListingTable .= "</td>\n\t<td align=center width=100><b>$$MyPrice</td>\n";
$ListingTable .= "</tr>\n";
}
$ListingTable .= "</table>";
}
///////////////////////////////////////////////////////////
///////////// 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 .= "<table align=center width=510 border=1 bordercolor=black frame=hsides rules=rows cellspacing=0>\n";
while($a1 = mysql_fetch_array($r1))
{
$TopTable .= "<tr onMouseOver=\"this.style.background='#E2E2E2'; this.style.cursor='hand'\" onMouseOut=\"this.style.background='white'\" onClick=\"window.open('info.php?id=$a1[ListingID]', '_top')\">\n\t";
if($a1[PriorityLevel] > '1')
{
$sub = "<span class=RedLink><sup>$a1[PriorityName]</sup></span>";
}
else
{
$sub = "";
}
$TopTable .= "\n\t<td width=15>";
if(!empty($a1[image]))
{
$TopTable .= "<img src=\"myimages/camera.jpg\" width=15 height=15>";
}
$TopTable .= "</td>\n\t";
$TopTable .= "<td width=305>$a1[city], $a1[state], $a1[address] $sub</td>\n\t";
$TopTable .= "<td width=80>$a1[rooms] br, $a1[bathrooms] ba";
$MyPrice = number_format($a1[Price], 2, ".", ",");
$TopTable .= "</td>\n\t<td align=center width=100><b>$$MyPrice</td>\n";
$TopTable .= "</tr>\n";
}
$TopTable .= "</table>";
}
//TRY ADDING THIS
echo "</td>\n<td>\n\t";
//END
require_once("templates/IndexTemplate.php");
echo "<br>";
require_once("templates/FooterTemplate.php");
?>