Connecticut Self Storage Locator By CITY
Search for a Self Storage Facility near you by choosing a City
\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 city FROM fieldnewest4 ORDER BY city ASC";
$result=mysql_query($query);
$error=mysql_error();
if($error){
print "mySQL query:$query";
print "mySQL error:$error";
}
print "";
echo'';
if($_GET['ct']) {
$selected_city=$_GET['ct'];
$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 city='$selected_city'";
$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]
";
}
}
?>
