require_once("conn.php");
require_once("includes.php");
//print_r($_SESSION);
?>
$listcat="";
$q2 = "select * from re2_subcategories order by SubcategoryName ";
$r2 = mysql_query($q2) or die(mysql_error());
if(mysql_num_rows($r2) > '0')
{
while($a2 = mysql_fetch_array($r2))
{
$listcat.="
| $a2[SubcategoryName] |
";
}}
$SelectCategory = "\n";
$Selectarea = "\n";
$CityMenu = "\n";
$news="";
$q1 = "select * from re2_news where active='Y' order by newsid desc ";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) >0)
{
while($a1 = mysql_fetch_array($r1))
{
$news.="".$a1[newstitle].""."
".$a1[description]."
";
}
}
$q1 = "select * from re2_listings order by ListingID DESC limit 0, 10 ";
$qnav = "select * from re2_listings, re2_agents where re2_listings.AgentID = re2_agents.AgentID $MyQuery";
$r1 = mysql_query($q1) or die(mysql_error());
$lrows = mysql_num_rows($r1);
if($lrows > '0')
{
$ListingTable .= "\n";
while($a1 = mysql_fetch_array($r1))
{
//echo "";
//print_r($a1);
$q2 = "select * from re2_area where areaid = '$a1[areaid]' ";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);
$ListingTable .= "";
if($a1[CategoryID]=='3')
{
$catnm = "For Sale";
}
if($a1[CategoryID]=='4')
{
$catnm = "For Rent";
}
if($a1[CategoryID]=='5')
{
$catnm = "Both";
}
if($a1[PriorityLevel] > '1')
{
$sub = "$a1[PriorityName]";
}
$ListingTable .= ""; if(!empty($a1[image]))
{
//$ListingTable .= " ";
}
$ListingTable .= " | ";
$ListingTable .= "| $a2[areaname]$sub | ";
//$ListingTable .= "| $catnm | \n\t";
//$ListingTable .= "| $a1[rooms] br, $a1[bathrooms] ba";
$MyPrice = number_format($a1[Price], 2, ".", ",");
$ListingTable .= " | $MyPrice INR | ";
$ListingTable .= "
";
}
$ListingTable .= "
";
}
$submsg="";
if($_REQUEST['Submit']=="Subscribe Me"){
if($_REQUEST['subscribemail']!=""){
$mail=$_REQUEST['subscribemail'];
$qsubmail = "select * from re2_subscribe where mail = '$mail'";
$rsubmail = mysql_query($qsubmail) or die(mysql_error());
if(mysql_num_rows($rsubmail) == '1')
{
$submsg="You have already subscribe.";
}else{
$todays=date("Y-m-d");
$subinsert="insert into re2_subscribe values ('','$mail','$todays')";
mysql_query($subinsert)or die(mysql_error());
$submsg="Subscribe Successfully! ";
}
}
}
$qpath = "select * from featuredagaentpath where status='Active'";
$rpath = mysql_query($qpath) or die(mysql_error());
$flg=0;
if(mysql_num_rows($rpath) == '1')
{
$apath = mysql_fetch_array($rpath);
$path=$apath['path'];
$flg=1;
}else{
$flg=0;
}
?>
EAAP