Listing Inquiry Page
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");
$ContactSelectStr = "SELECT * FROM " . $TablePrefix . "_Sells_Contacts WHERE SellsContactID = '$contact'";
$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");
// Now Grab Property Info
$SelectStr = "SELECT * FROM " . $TablePrefix . "_Property_Listings WHERE PropertyListingID = '$property'";
$Results = MySQL($dbName,$SelectStr);
$RowCount = MySQL_NUMROWS($Results);
$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");
?>
|
|
|
 |
 |
|
 |
 |
| 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 |
|
|
|
|
|
|
 |
| |
|