"Poe_Session", "auth" => "Poe_Auth")); $dbProperty = new DB_Poe; $dbProperty->connect(); $dbMap = new DB_Poe; $dbMap->connect(); ?> query($query); $dbProperty->next_record(); $query = sprintf("SELECT * FROM Map WHERE MapID='$s'",$dbProperty->f("MapID")); $dbMap->query($query); $dbMap->next_record(); $PropertyID = $dbProperty->f("PropertyID"); break; case("Modify"): $query = sprintf("UPDATE Property SET PropertyID='%s', PropertyNumber='%s', Description='%s', Price='%s', MapID='%s', Name='%s', Photo='%s', Color='%s' WHERE PropertyID='%s'", $PropertyID, addslashes(trim($PropertyNumber)), addslashes(trim($Description)), addslashes(trim($Price)),$MapID, addslashes(trim($Name)), addslashes(trim($Photo)), addslashes(trim($Color)), $PropertyID); $dbProperty->query($query); unset($PropertyID); break; case("Delete"): $query="DELETE FROM Property WHERE PropertyID='$PropertyID'"; $dbProperty->query("$query"); unset($PropertyID); break; case("Add"): $Query_String = sprintf("INSERT INTO Property VALUES(NULL,'%s','%s','%s','%s','%s','%s','%s')", addslashes(trim($PropertyNumber)), addslashes(trim($Description)), addslashes(trim($Price)), $MapID, addslashes(trim($Name)), addslashes(trim($Photo)), addslashes(trim($Color))); $dbProperty->query($Query_String); $dbProperty->query("SELECT * FROM Property WHERE PropertyID = '$PropertyID'"); $dbProperty->next_record(); $PropertyID = $dbProperty->f("PropertyID"); break; }//switch ?>
Property Modification

query($PropertyQuery); ?>

Property:

next_record()) { ?> ">f("PropertyNumber")))); ?>

query($query); $dbProperty->next_record(); } ?> query($MapQuery); ?>

Click to veiw map colors The Ranch Gains Bend The Cliffs Hogg Bend Sportsmans world West Side Peninsula North P. K. Graham Farm and Ranch	Map Location:	next_record()) { if($dbProperty->f("MapID") == $dbMap->f("MapID")) { ?> ">f("MapName"))); ?> ">f("MapName")))."\n";?>
	Property Number:	" SIZE="20" MAXLENGTH="70" >
	Name:	" SIZE="20" MAXLENGTH="70" >
	Description:	<? printf(stripslashes($dbProperty->f("Description"))); ?>
	Price:	" SIZE="20" MAXLENGTH="70" >
	Photo:	" SIZE="20" MAXLENGTH="70" >
	Map Color:	" SIZE="20" MAXLENGTH="70" >

"> Property has been modified!\n" : ""); ?>

Administration