"; ?> insert();?> "; echo ""; while ((list($zipcode, $long, $lat, $pop, $state, $city) = mysql_fetch_row($result))) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } elseif ($latlong == "true" and $pop == ""){ $result = mysql_query("select zipcode, longitude, latitude, States.state, City.city from Zipdata, States, City where Zipdata.stateid=States.stateid and Zipdata.cityid=City.cityid and City.city='$Cityname' order by zipcode", $link_id); echo mysql_error() . "
"; echo "

$city

$state

$zipcode

$lat

$long

$pop

"; while ((list($zipcode, $long, $lat, $state, $city) = mysql_fetch_row($result))) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } elseif ($latlong == "" and $pop == "true"){ $result = mysql_query("select zipcode, population, States.state, City.city from Zipdata, States, City where Zipdata.stateid=States.stateid and Zipdata.cityid=City.cityid and City.city='$Cityname' order by zipcode", $link_id); echo mysql_error() . "
"; echo "

$city

$state

$zipcode

$lat

$long

"; while ((list($zipcode, $pop, $state, $city) = mysql_fetch_row($result))) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } else { $result = mysql_query("select zipcode, States.state, City.city from Zipdata, States, City where Zipdata.stateid=States.stateid and Zipdata.cityid=City.cityid and City.city='$Cityname' order by zipcode", $link_id); echo mysql_error() . "
"; echo "

$city

$state

$zipcode

$pop

"; while ((list($zipcode, $state, $city) = mysql_fetch_row($result))) { echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "

$city

$state

$zipcode

"; ?> insert(); ?> "; ?>