include("Variables.php");
mysql_connect("localhost",$MysqlName,$MysqlPW) or die("Unable to connect to SQL server");
@mysql_select_db("$dbName") or die("Unable to select database");
$featuredSelectStr = "SELECT * FROM " . $TablePrefix . "_Property_FeaturedItem";
$fResults = MySQL($dbName,$featuredSelectStr);
$fRowCount = MySQL_NUMROWS($fResults);
$recordid = MySQL_RESULT($fResults,0,"PropertyID");
$SelectStr = "SELECT * FROM " . $TablePrefix . "_Property_Listings WHERE PropertyListingID = '$recordid'";
$Results = MySQL($dbName,$SelectStr);
$RowCount = MySQL_NUMROWS($Results);
?>
Wildwood Properties
$price = MySQL_RESULT($Results,$i,"PropertyListingPricePerAcre");
$title = MySQL_RESULT($Results,$i,"PropertyListingTitle");
$category = MySQL_RESULT($Results,$i,"PropertyListingCategory");
$size = MySQL_RESULT($Results,$i,"PropertyListingSize");
$status = MySQL_RESULT($Results,$i,"PropertyListingStatus");
$county = MySQL_RESULT($Results,$i,"PropertyListingCounty");
$state = MySQL_RESULT($Results,$i,"PropertyListingState");
$contact1 = MySQL_RESULT($Results,$i,"PropertyListingContact1");
$contact2 = MySQL_RESULT($Results,$i,"PropertyListingContact2");
$thetext = MySQL_RESULT($Results,$i,"PropertyListingText");
$textfile= $textfilepath .$thetext .".txt";
// print "$textfile
";
// Make Sure File Exists Before Opening It
if (!file_exists($textfile)) {
$buffer="";
}
else {
$descriptionfile = fopen("$textfile", "r");
$buffer = fread($descriptionfile, filesize ($textfile));
fclose ($descriptionfile);
}
// Now Get the contact
$ContactSelectStr = "SELECT * FROM " . $TablePrefix . "_Sells_Contacts WHERE SellsContactID = '$contact1'";
$ContactResults = MySQL($dbName,$ContactSelectStr);
$ContactRowCount = MySQL_NUMROWS($ContactResults);
$cfname = MySQL_RESULT($ContactResults,0,"SellsContactFirstName");
$clname = MySQL_RESULT($ContactResults,0,"SellsContactLastName");
$cemail = MySQL_RESULT($ContactResults,0,"SellsContactEmail");
$cphone = MySQL_RESULT($ContactResults,0,"SellsContactPhone");
$cpic = MySQL_RESULT($ContactResults,0,"SellsContactImage");
?>
|
 |
Print " "; ?>
|
| Contact
Infomation: |
Name: |
Print "$cfname $clname"; ?> |
Phone: |
Print "$cphone"; ?> |
Email: |
Print "$cemail"; ?> |
|
Size / Acerage |
Print "$size"; ?> |
| Price
per Acre |
$ Print "$price"; ?>
|
| State: |
Print"$state"; ?> |
| County: |
Print"$county County"; ?>
|
| Status: |
Print"$status"; ?>
|
|
mysql_connect("localhost",$MysqlName,$MysqlPW) or die("Unable to connect to SQL server");
@mysql_select_db("$dbName") or die("Unable to select database");
$PicSelectStr = "SELECT * FROM " . $TablePrefix . "_Property_Images WHERE 1 AND `PropertyListingID-FK` = $recordid";
$PicResults = MySQL($dbName,$PicSelectStr);
$PicRowCount = MySQL_NUMROWS($PicResults);
if ($PicRowCount > 0) {
$pic1 = MySQL_RESULT($PicResults,0,"PropertyImage1");
$pic2 = MySQL_RESULT($PicResults,0,"PropertyImage2");
$pic3 = MySQL_RESULT($PicResults,0,"PropertyImage3");
$pic4 = MySQL_RESULT($PicResults,0,"PropertyImage4");
$pic5 = MySQL_RESULT($PicResults,0,"PropertyImage5");
$topo = MySQL_RESULT($PicResults,0,"PropertyImageTopo");
$arial = MySQL_RESULT($PicResults,0,"PropertyImagearial");
$loc = MySQL_RESULT($PicResults,0,"PropertyImageLocation");
$FrontPicSelectStr = "SELECT * FROM " . $TablePrefix . "_Property_FrontPics WHERE 1 AND `FrontPicID-FK` = $recordid";
$FrontPicResults = MySQL($dbName,$FrontPicSelectStr);
$FrontPicRowCount = MySQL_NUMROWS($FrontPicResults);
if ($FrontPicRowCount > 0) {
$FrontPicImage=MySQL_RESULT($FrontPicResults,0,"FrontPicImage");
if ($FrontPicImage != "None") {
Print " ";
}
}
}
?>
|
Description:
|
Print "$buffer"; ?> |
|
if (($pic1 !="None") & ($pic1 !="")){
Print " ";
}
?>
|
if (($pic2 !="None") & ($pic2 !="")) {
Print " ";
}
?>
|
if (($pic3 !="None") & ($pic3 !="")) {
Print " ";
}
?>
|
if (($pic4 !="None") & ($pic4 !="")) {
Print " ";
}
?>
|
if (($pic5 !="None") & ($pic5 !="")) {
Print " ";
}
?>
|
Maps
for This Listing: |
if (($arial !="None") & ($arial !="")) {
Print " ";
}
?>
|
if (($topo !="None") & ($topo !="")) {
Print " ";
}
?>
|
if (($loc !="None") & ($loc !="")) {
Print " ";
}
?>
|
Disclaimer |
|
|
|
 |
 |
|
 |
 |
| Needmore Properties
P.O. Box 70995• Albany, Georgia 31708 • 229-439-1837
Broker Number: H-54562
Wildwood Properties
P.O. Box 70483• Albany, Georgia 31708 • 229-883-7174
Broker Number: H-31593 |
|
|
|
|
|
|
 |
| |
|