google_ad_client = "pub-2828711705598959"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "000000"; google_color_text = "000000"; google_color_url = "008000"; //-->

Midtown Real Estate

require_once 'DB.php'; include("mySQLpref.php"); include("functions.php"); //$agentID=$_GET['agentID']; //$hood=$_GET['hood']; $db = DB::connect($dsn); if (DB::isError($db)) { // get the native backend error // and the last query //echo $db->getDebugInfo(); echo "

Sorry, we are experiencing heavy network traffic on our database server. Please try back in about 15 minutes.

"; exit; } $sql= "SELECT count(*) from real_estate WHERE sold='No' and agentID='".$agentID."'"; //print ""; $countNum=$db->getOne($sql); chkSqlError($db); if ($countNum==0) { echo ""; exit; } else { $getAgentInfo="select firstName,lastName, phoneNumber from real_estate_users where agentID=$agentID"; $agentInfo=$db->getRow($getAgentInfo); $agentFirstName=$agentInfo[0]; $agentLastName=$agentInfo[1]; $agentPhone=$agentInfo[2]; if ($hood==""){ $getSQL= "select distinct listingID, listingDate, sold, city, state, listingType, price, bed, bath,sqFeet,mlsID,shortDesc,photo,hood,triumphLinkURL FROM real_estate where agentID='".$agentID."' and sold='No' ORDER BY hood DESC"; } else { $getSQL= "select distinct listingID, listingDate, sold, city, state, listingType, price, bed, bath,sqFeet,mlsID,shortDesc,photo,hood,triumphLinkURL FROM real_estate where agentID='".$agentID."' and sold='No' and hood='".$hood."'ORDER BY bed DESC"; } //print ""; $results=$db->query($getSQL); chkSqlError($db); $howMany=$results->numRows(); if ($howMany!=0) { echo ''; //fetch all $db->setFetchMode(DB_FETCHMODE_ASSOC); $color=1; foreach (range(0,$howMany) as $rownum) { if (!$result = $results->fetchrow(DB_FETCHMODE_ORDERED,$rownum)) { break; } if (($color%2)==0) { print""; } else { echo ""; } //format the price $listPrice="\$".number_format($result[6]); $imageFileName=$result[12]; $imageTag=superSmallImageResizer($imageFileName,$result[3],$result[4]); $sqFeet=number_format($result[9]); $neighborhood=$result[13]; $neighborhood=ucwords($neighborhood); echo ""; $color++; } } echo "

Description	Neighborhood	Beds / Baths	Approx Sq Feet*	Price	Contact Info
$imageTag {$result[11]}	$neighborhood	{$result[7]} / {$result[8]}	{$sqFeet} Sq ft*	{$listPrice}	Agent: $agentFirstName $agentLastName $agentPhone Click Here For More Details

"; } // else count==0 ?> google_ad_client = "pub-2828711705598959"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "000000"; google_color_text = "000000"; google_color_url = "008000"; //-->