 |
Florida regions, counties and communities list. |
Detailed Community Search
(Search by price ranges, cities, bedrooms and more)
$query="select * from rf_floridaregion order by fr_ID";
$rs=mysql_query($query);
while($row=mysql_fetch_array($rs))
{
$query1="select * from rf_floridacounties where cnty_RegionID=".$row['fr_ID']." order by cnty_Name";
$rs1=mysql_query($query1) or die(mysql_error());
echo " ";
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 " | ";
}
}
}
}
?>
|
|
|
|
|