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++;
}
?>
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
-
Las Vegas Quickbooks Consultant
-
making affordable and Quality Websites
-
making affordable and Quality Websites
-
making affordable and Quality Websites
-
Custom Picture Framing | Customized Frames
-
Home of professional website design for Churches
-
We do it right the first time!
-
making affordable and Quality Websites
-
We don't cut corners!
-
making affordable and Quality Websites
-
Search Engine Optimization (SEO) Support Link
-
Las Vegas Landscaping | Las Vegas Building Mainten
-
Honest, Reliable, and Affordable Services
-
Excellent yet affordable cleaning service.
-
Professional Website Design | Domain Registration
-
Weight Loss in Las Vegas
-
US Visa Assistance | US Immigration Information
-
Las Vegas Carpets, Tiles, Laminates, Vinyl, VCT
-
-
Grants Funding and Grant Writing
-
-
Sarah Palin is a Hunter
-
-
making affordable and Quality Websites
-
The Home of $3.99 Pho
-
Everything old is new again
-
-
making affordable and Quality Websites
-
-
Free Church website design and setup
-
Welcome to the Church Family in Las Vegas!
-
Cheapest Flooring Materials in Las Vegas
|
|
|
|
|
|
| |
|
| |
|
|
|
|
|
|
|
|
|