Home || Previous Page\n";
$action = $_REQUEST[action];
if($action == 'showcities'){
$ctr=0;
echo "\n";
$result = mysql_query("SELECT distinct city from tire_centers where state='$_REQUEST[state]' order by city", $db);
while($myrow = mysql_fetch_array($result)){
$ctr++;
$cityfixed = str_replace(' ', '_', $myrow[city]);
if($ctr == 1){
echo " | $myrow[city] | ";
}
elseif($ctr == 2){
echo "$myrow[city] | ";
}
else {
echo "$myrow[city] |
\n";
$ctr=0;
}
}
if($ctr == 1){ echo " | | \n"; }
elseif($ctr == 2){ echo " | \n"; }
echo "
\n";
}
elseif($action == 'listings'){
$city = str_replace('_', ' ', $_REQUEST[city]);
echo "Available Listings for $city, $_REQUEST[state]
\n";
echo "\n";
$result = mysql_query("SELECT * from tire_centers where state='$_REQUEST[state]' and city='$city'", $db);
while($myrow = mysql_fetch_array($result)){
echo " \n";
echo " | $myrow[name] | \n";
echo " $myrow[street] | \n";
$meurl = '/tire-centers/' . $_REQUEST[state] . '/' . $_REQUEST[city] . '/store' . $myrow[id] . '.html';
echo " View Profile | \n";
echo "
\n";
echo " | |
\n";
}
echo "
More Information for this City
\n";
$location = $_REQUEST[city] . ' ' . $_REQUEST[state];
$locale = str_replace("\,","+",$location);
$locale = str_replace(" ","+",$locale);
$searchterm = 'Tires';
$searchterm = $searchterm . '+' . $locale;
CarpConf('shownoitems',1);
CarpConf('noitems','');
CarpConf('encodingin','UTF-8');
CarpConf('encodingout','UTF-8');
CarpConf('fixentities',1);
CarpConf('cborder','');
CarpConf('bi','');
CarpConf('aidesc','
');
CarpConf('ilinkstyle','text-decoration:none');
CarpConf('cacheinterval',120);
CarpConf('maxitems',5);
CarpConf('linktarget',1);
CarpConf('poweredby','');
CarpCacheShow("http://beta.search.msn.com/results.aspx?q=$searchterm&format=rss");
}
elseif($action == 'details'){
$city = str_replace('_', ' ', $_REQUEST[city]);
$result = mysql_query("SELECT * from tire_centers where id='$_REQUEST[id]'", $db);
$myrow = mysql_fetch_array($result);
echo <<$myrow[name]
$myrow[street]
$myrow[city], $myrow[state] $myrow[zip]
Contact Information
Phone: $myrow[phone]
Fax: $myrow[fax]
EOT;
if($myrow[website] != ''){ echo "Visit Website
\n"; } else { echo "\n"; }
echo "More Information for this Company
\n";
$location = $city . ' ' . $_REQUEST[state];
$locale = str_replace("\,","+",$location);
$locale = str_replace(" ","+",$locale);
$searchterm = str_replace(" ", "+", $myrow[name]);
$searchterm = $searchterm . '+' . $locale;
CarpConf('shownoitems',1);
CarpConf('noitems','');
CarpConf('encodingin','UTF-8');
CarpConf('encodingout','UTF-8');
CarpConf('fixentities',1);
CarpConf('cborder','');
CarpConf('bi','');
CarpConf('aidesc','
');
CarpConf('ilinkstyle','text-decoration:none');
CarpConf('cacheinterval',120);
CarpConf('maxitems',5);
CarpConf('linktarget',1);
CarpConf('poweredby','');
CarpCacheShow("http://beta.search.msn.com/results.aspx?q=$searchterm&format=rss");
}
else {
$ctr=0;
echo "\n";
$result = mysql_query("SELECT distinct state from tire_centers order by state", $db);
while($myrow = mysql_fetch_array($result)){
$myrow[state] = strtoupper($myrow[state]);
$query = mysql_query("SELECT name from states where twochar='$myrow[state]'", $db);
$row = mysql_fetch_array($query);
$state = ucwords(strtolower($row[name]));
$ctr++;
if($ctr == 1){
echo " | $state | ";
}
elseif($ctr == 2){
echo "$state | ";
}
else {
echo "$state |
\n";
$ctr=0;
}
}
if($ctr == 1){ echo " | | \n"; }
elseif($ctr == 2){ echo " | \n"; }
echo "
\n";
}
include("includes/footer.php");
exit;
?>