|
|
|
|
|
|
if($sel_property_com!="") {
$sel_property = $sel_property_com;
}
if($sel_property_res!="") {
$sel_property = $sel_property_res;
}
if($default[0]!='' && $sel_property=='')
$sel_property = $default[0];
$query="select property_name, address1, address2, city,property.state_id, zip, gen_tel, gen_fax, gen_email, lease_tel, lease_fax, lease_email, main_tel, main_fax, main_email, emg_tel, name from property,state where pid='".$sel_property."' and property.state_id = state.state_id";
//echo $query;
if(!($result=mysql_query($query)))
{
echo "for query" .$query." ".mysql_error();
}
$row=mysql_fetch_array($result);
?>
=$row['property_name']?>
=$row['address1']?>
=$row['city']?>, =$row['name']?> =$row['zip']?>
General:
Tel: =$row['gen_tel']?>
Fax: =$row['gen_fax']?>
Email: =$row['gen_email']?>
|
Leasing:
Tel: =$row['lease_tel']?>
Fax: =$row['lease_fax']?>
Email: =$row['lease_email']?> |
Maintenance:
Tel: =$row['main_tel']?>
Fax: =$row['main_fax']?>
Email: =$row['main_email']?> |
24 Hour Emergency Hotline:
Tel: =$row['emg_tel']?>
|
|
|  |
|
 |
|