 |
Florida regions, counties and communities list. |
Detailed Community Search
(Search by price ranges, cities, bedrooms and more)
| ";
echo " | ";
echo "";
echo ''.$row['fr_Name'].'
';
echo " | ";
echo "| ";
echo " | ";
while($row1=mysql_fetch_array($rs1))
{
$query2="select * from rf_cities A,rf_communities B where A.cty_countyID=".$row1['cnty_ID']." AND B.com_cityID=A.cty_ID AND B.com_pageUp='T' group by A.cty_ID order by A.cty_Name";
$rs2=mysql_query($query2);
echo "| | ";
echo ''.$row1['cnty_Name'].'';
echo " | ";
while($row2=mysql_fetch_array($rs2))
{
$query3="select * from rf_communities where com_cityID=".$row2['cty_ID']." AND com_pageUp='T' order by com_name";
$rs3=mysql_query($query3);
echo "| | | ";
echo ''.$row2['cty_Name'].'';
echo " | ";
while($row3=mysql_fetch_array($rs3))
{
if($row3['com_name']=="")
{
$com_name="Unknown Name";
}
else
{
$com_name=$row3['com_name'];
}
echo "| | | | ";
echo ''.$com_name.'';
echo " | ";
}
}
}
}
?>
|
|
|
|
|
