if ($sponsor_link_id!=""){
$sel_query= "WHERE sponsor_link_id='$sponsor_link_id'";
}
include("connector-db.inc.php");
$query="SELECT * FROM {$table} $sel_query";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$sponsor_link_id=mysql_result($result,$i,"sponsor_link_id");
$company_name=mysql_result($result,$i,"name_of_company");
$address_street=mysql_result($result,$i,"street");
$address_city=mysql_result($result,$i,"city");
$adress_state=mysql_result($result,$i,"state");
$zip_code=mysql_result($result,$i,"zip_code");
$address=$address_street.",".$address_city.",".$address_state.",".$address_zip_code;
$website_address=mysql_result($result,$i,"website_address");
$company_description=mysql_result($result,$i,"description");
$company_slogan=mysql_result($result,$i,"company_slogan");
$keyword1=mysql_result($result,$i,"keyword1");
$keyword2=mysql_result($result,$i,"keyword2");
$keyword3=mysql_result($result,$i,"keyword3");
$keyword4=mysql_result($result,$i,"keyword4");
$keyword5=mysql_result($result,$i,"keyword5");
//$page_filename1=str_replace(" ","_",$page_filename1);
$website_address=str_replace("http://","",$website_address);
$page_filename1=str_replace("http://"," ",$website_address);
$page_filename1=str_replace("www."," ",$page_filename1);
$page_filename1=str_replace(".com"," ",$page_filename1);
$page_filename1=str_replace("/"," ",$page_filename1);
$page_filename1=trim(strtolower($page_filename1));
$page_filename2=trim(strtolower($address_city));
$page_filename2=str_replace(" ","_",$page_filename2);
$page_filename3=trim(strtolower($company_slogan));
$page_filename3=str_replace(" ","_",$page_filename3);
$page_filename=$page_filename2."_".$page_filename3."_".$page_filename1.".php";
$page_title=ucwords($address_city." | ".$company_name." | ".$company_slogan);
$page_description=ucwords($company_description);
$page_keyword=strtolower($keyword1.",".$keyword2.",".$keyword3.",".$keyword4.",".$keyword5);
$i++;
}
?>
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
-
One Stop Shop for Small Business
-
Providing Affordable Web Design
-
making affordable and Quality Websites
-
making affordable and Quality Websites
-
making affordable and Quality Websites
-
Custom Picture Framing
-
The best carpet store town!
-
making affordable and Quality Websites
-
-
making affordable and Quality Websites
-
Your link to better SEO results!
-
Las Vegas Yard Maintenance and Landscaping
-
Honest, Reliable, and Affordable Services
-
Excellent yet affordable carpet cleaning
-
Las Vegas Lawyer
-
Weight Loss in Las Vegas
-
Las Vegas Carpet, Tiles, Laminates, Vinyl, VCT
-
-
SOLVING THE PUZZLE OF BUSINESS SUCCESS
-
-
Sarah Palin is a Hunter
-
-
making affordable and Quality Websites
-
Everything old is new again.
-
Everything old is new again
-
-
making affordable and Quality Websites
-
-
A Ministry that helps Non-Denominational Churches
-
-
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
Copyright ©
Access Business Systems 2008.-
/
, and by Access Web Development, a Division of , a Company. Sitemap |
|