Connecticut Self Storage Locator By ZIP CODE

Search for a Self Storage Facility near you by choosing a Zip Code

\n"; $link = mysql_connect('localhost:6033','jnovenstein','fancy'); if (!$link){ print "Can't connect to localhost. The error is
"; print mysql_connect_error(); print "
"; } mysql_select_db('jnovenstein'); $query="SELECT postalcode FROM fieldnewest4 ORDER BY postalcode ASC"; $result=mysql_query($query); $error=mysql_error(); if($error){ print "mySQL query:$query"; print "mySQL error:$error"; } print "

"; echo'

'; if($_GET['zip']) { $selected_postal=$_GET['zip']; $link = mysql_connect('localhost:6033','jnovenstein','fancy'); if (!$link){ print "Can't connect to localhost. The error is
"; print mysql_connect_error(); print "
"; } mysql_select_db('jnovenstein'); $query="SELECT city,company,address1,address2,state, postalcode, phone FROM fieldnewest4 WHERE postalcode='$selected_postal'"; $result=mysql_query($query); $error=mysql_error(); if($error){ print "mySQL query:$query"; print "mySQL error:$error"; } //$fields=array('city','company'); while($columns=mysql_fetch_array($result)) { print "

$columns[company]
"; print "$columns[address1]
"; //print "$columns[address2]
"; print "$columns[city], "; print "$columns[state] "; print "$columns[postalcode]
"; print "$columns[phone]

"; } } ?>

Valid XHTML 1.0!