".$display_statefull.""; }
?>
[ Admin Menu | Logout"; } ?>
Edit SEO Page Text ]"; }
$sql2 = "select * from cm_sepages where sepageName = \"none\"";
if ($result2 = @mysql_query ("$sql2")) {
while ($row2 = @mysql_fetch_array ($result2)) {
$page_text = $row2[sepageText];
}
}
echo $page_text;
echo "";
while ($row = @mysql_fetch_array ($result)) {
$statefull = str_replace(" ","-",$row[statefull]);
echo "- ".$row[statefull]."
";
}
echo "
";
}
} elseif ( ($county == "") && ($city == "") ) { // if no county variable, then build county list
$statefull_db = str_replace("-"," ",$statefull);
$sql = "select distinct county from cm_zipcodes where statefull = \"$statefull_db\" order by county asc";
if ($result = @mysql_query ("$sql")) {
if ($cdgCMadmin == "admin") { echo " | Edit SEO Page Text ]"; }
$sql2 = "select * from cm_sepages where sepageName = \"state\"";
if ($result2 = @mysql_query ("$sql2")) {
while ($row2 = @mysql_fetch_array ($result2)) {
$page_text = $row2[sepageText];
}
}
$page_text = str_replace("",$display_statefull,$page_text);
echo $page_text;
echo "";
}
} elseif (($city == "") && ($term == "") ) { // if no city variable, then build city list
$statefull_db = str_replace("-"," ",$statefull);
$county_db = str_replace("-"," ",$county);
$sql = "select distinct city from cm_zipcodes where county = \"$county_db\" order by city asc";
if ($result = @mysql_query ("$sql")) {
if ($cdgCMadmin == "admin") { echo " | Add Zip Code | Edit SEO Page Text ]"; }
$sql2 = "select * from cm_sepages where sepageName = \"county\"";
if ($result2 = @mysql_query ("$sql2")) {
while ($row2 = @mysql_fetch_array ($result2)) {
$page_text = $row2[sepageText];
}
}
$page_text = str_replace("",$statefull_db,$page_text);
$page_text = str_replace("",$county_db,$page_text);
echo $page_text;
echo "";
}
} elseif (($term == "") && ($city != "") ) { //if no term variable, then build term list
$sql = "select * from cm_sekeywords order by sekeyword asc";
if ($result = @mysql_query ("$sql")) {
if ($cdgCMadmin == "admin") { echo " | Add Keyword | Edit SEO Page Text ]"; }
$statefull_db = str_replace("-"," ",$statefull);
$county_db = str_replace("-"," ",$county);
$city_db = str_replace("-"," ",$city);
$sql2 = "select * from cm_sepages where sepageName = \"city\"";
if ($result2 = @mysql_query ("$sql2")) {
while ($row2 = @mysql_fetch_array ($result2)) {
$page_text = $row2[sepageText];
}
}
$page_text = str_replace("",$statefull_db,$page_text);
$page_text = str_replace("",$county_db,$page_text);
$page_text = str_replace("",$city_db,$page_text);
echo $page_text;
echo "";
while ($row = @mysql_fetch_array ($result)) {
$term = str_replace(" ","-",ucwords($row[sekeyword]));
echo "- ".ucwords($row[sekeyword])."
";
}
echo "
";
}
} else { //if all variables assigned, then build keyword term page
$sql = "select * from cm_sekeywords where keywordID = \"$termID\"";
if ($result = @mysql_query ("$sql")) {
while ($row = @mysql_fetch_array ($result)) {
$display_city = str_replace("-"," ",$city);
$display_county = str_replace("-"," ",$county);
$display_statefull = str_replace("-"," ",$statefull);
$sql2 = "select * from cm_sekeywords order by sekeyword asc";
if ($result2 = @mysql_query ("$sql2")) {
$term_list_block = "\n";
}
$text = str_replace("",$display_statefull,$row[sekeywordText]);
$text = str_replace("",$display_county,$text);
$text = str_replace("",$display_city,$text);
$text = str_replace("",str_replace("-"," ",ucwords($term)),$text);
$text = str_replace("",$term_list_block,$text);
if ($cdgCMadmin == "admin") { echo " | Edit Keyword | Delete ]"; }
echo $text;
}
}
}
?>
Contact us today!