".$row_title["business_name"]."
";
include("/home/".$business_id_gen."/site_files/random.php");
$site ="SELECT * FROM ".$business_id_gen."_site_map order by order_no";
$site_results = mysql_query($site);
echo '
';
$count = 0;
while ($site_col = mysql_fetch_array($site_results)) {
//website pages
if ($site_col['site_map_ref'] == "shop") {
$count ++;
if ($count == 1){
echo '
'.$row_title["business_name"].' Online Shop
'.$row_title["business_name"].' Online Shop
';
}
include ("database_script.php");
$hostname12 = "localhost";
$username12 = $business_id_gen."_shop";
$password12 = $password1;
$dbh12 = mysql_connect($hostname12, $username12, $password12) or die("Unable to connect to MySQL ". mysql_error());
$dbasename12 = $business_id_gen."_shop";
mysql_select_db ($dbasename12, $dbh12) or die("Could not select $dbasename12");
$shop ="SELECT * FROM products";
$shop_results = mysql_query($shop);
while ($shop_col = mysql_fetch_array($shop_results)) {
$shop_title ="SELECT * FROM products_description where products_id='".$shop_col['products_id']."'";
$shop_results_title = mysql_query($shop_title);
$shop_col_title = mysql_fetch_array($shop_results_title);
$value = $shop_col_title["products_name"];
echo '
'.
$value
.'';
}
}
else if ($site_col['site_map_ref'] == "cat") {
$count ++;
if ($count == 1){
echo '
'.$row_title["business_name"].' Online Shop
';
}
include ("database_script.php");
$hostname12 = "localhost";
$username12 = $business_id_gen."_shop";
$password12 = $password1;
$dbh12 = mysql_connect($hostname12, $username12, $password12) or die("Unable to connect to MySQL ". mysql_error());
$dbasename12 = $business_id_gen."_shop";
mysql_select_db ($dbasename12, $dbh12) or die("Could not select $dbasename12");
$shop2 ="SELECT * FROM categories";
$shop_results2 = mysql_query($shop2);
while ($shop_col2 = mysql_fetch_array($shop_results2)) {
$shop_title2 ="SELECT * FROM categories_description where categories_id='".$shop_col2['categories_id']."'";
$shop_results_title2 = mysql_query($shop_title2);
$shop_col_title2 = mysql_fetch_array($shop_results_title2);
$value2 = $shop_col_title2["categories_name"];
echo '
'.
$value2
.'';
}
}
else {
echo '
'.
$site_col["page_title"]
.'';
}
}
include ("database_script.php");
echo '
Google XML Sitemap';
echo '
';
?>
