|
|
DESCRIPTION |
TYPE |
STATUS |
ASSOCIATE |
DETAILS |
");
if (($picorg!="")||($picorg!=null)) {
echo("![](\"../pics/$pic\") ");
}else{
echo("![](\"../imagecoming.gif\") ");
}
echo(" |
$shortdesc
");
if (($address!="")||($address!=null)) {
echo("$address
");
}
if (($address2!="")||($address2!=null)) {
echo("$address2
");
}
if (($city!="")||($city!=null)) {
echo("$city, ");
}
if (($state!="")||($state!=null)) {
echo("$state ");
}
if (($zipcode!="")||($zipcode!=null)) {
echo("$zipcode");
}
echo("
|
");
if ($t_industrial=="yes") {
echo("Industrial
");
}
if ($t_office=="yes") {
echo("Office
");
}
if ($t_retail=="yes") {
echo("Retail
");
}
if ($t_land=="yes") {
echo("Land
");
}
if ($t_investment=="yes") {
echo("Investment
");
}
if ($t_officewarehouse=="yes") {
echo("Office/Warehouse
");
}
if ($t_other=="yes") {
echo("Other");
}
echo(" |
");
if ($cs_forlease=="yes") {
echo("For Lease
");
}
if ($cs_forsale=="yes") {
echo("For Sale
");
}
if ($cs_sold=="yes") {
echo("Sold
");
}
if ($cs_leased=="yes") {
echo("Leased
");
}
if ($cs_undercontract=="yes") {
echo("Under Contract");
}
echo(" |
");
$sql3 = "SELECT * FROM `listingassoc` WHERE 1 AND `listingid` = $id ORDER BY id ";
$result3 = mysql_query($sql3);
if($result3 != null) {
while ($item3 = mysql_fetch_array($result3)) {
$id2 = $item3["id"];
$associd = $item3["associd"];
if ($associd!=0) {
$sql2 = "SELECT * FROM `associate` WHERE 1 AND `id` = $associd";
$result2 = mysql_query($sql2);
if($result2 != null) {
$item2 = mysql_fetch_array($result2);
$fname = $item2["fname"];
$lname = $item2["lname"];
echo("$fname $lname
");
}
}
}
}
echo(" |
![](\"../pprofile2.gif\")
|
");
}
$item = mysql_fetch_array($result);
if($item != null) {
//foreach($result as $item)
$id = $item["id"];
$cs_forlease = $item["cs_forlease"];
$cs_forsale = $item["cs_forsale"];
$cs_sold = $item["cs_sold"];
$cs_leased = $item["cs_leased"];
$cs_undercontract = $item["cs_undercontract"];
$shortdesc = $item["shortdesc"];
$t_industrial = $item["t_industrial"];
$t_office = $item["t_office"];
$t_retail = $item["t_retail"];
$t_land = $item["t_land"];
$t_investment = $item["t_investment"];
$t_officewarehouse = $item["t_officewarehouse"];
$t_other = $item["t_other"];
$address = $item["address"];
$address2 = $item["address2"];
$city = $item["city"];
$state = $item["state"];
$zipcode = $item["zipcode"];
$picorg = $item["pic1"];
$pic = $id."L_pic1tn.jpg";
echo("
|
");
if (($picorg!="")||($picorg!=null)) {
echo("");
}else{
echo("");
}
echo(" |
$shortdesc
");
if (($address!="")||($address!=null)) {
echo("$address
");
}
if (($address2!="")||($address2!=null)) {
echo("$address2
");
}
if (($city!="")||($city!=null)) {
echo("$city, ");
}
if (($state!="")||($state!=null)) {
echo("$state ");
}
if (($zipcode!="")||($zipcode!=null)) {
echo("$zipcode");
}
echo("
|
");
if ($t_industrial=="yes") {
echo("Industrial
");
}
if ($t_office=="yes") {
echo("Office
");
}
if ($t_retail=="yes") {
echo("Retail
");
}
if ($t_land=="yes") {
echo("Land
");
}
if ($t_investment=="yes") {
echo("Investment
");
}
if ($t_officewarehouse=="yes") {
echo("Office/Warehouse
");
}
if ($t_other=="yes") {
echo("Other");
}
echo(" |
");
if ($cs_forlease=="yes") {
echo("For Lease
");
}
if ($cs_forsale=="yes") {
echo("For Sale
");
}
if ($cs_sold=="yes") {
echo("Sold
");
}
if ($cs_leased=="yes") {
echo("Leased
");
}
if ($cs_undercontract=="yes") {
echo("Under Contract");
}
echo(" |
");
$sql3 = "SELECT * FROM `listingassoc` WHERE 1 AND `listingid` = $id ORDER BY id ";
$result3 = mysql_query($sql3);
if($result3 != null) {
while ($item3 = mysql_fetch_array($result3)) {
$id2 = $item3["id"];
$associd = $item3["associd"];
if ($associd!=0) {
$sql2 = "SELECT * FROM `associate` WHERE 1 AND `id` = $associd";
$result2 = mysql_query($sql2);
if($result2 != null) {
$item2 = mysql_fetch_array($result2);
$fname = $item2["fname"];
$lname = $item2["lname"];
echo("$fname $lname
");
}
}
}
}
echo(" |
![](\"../pprofile.gif\")
|
");
}
}
}
?>
