0) { $region_arr = $region_arr[0]; $place["r"] = $region_arr["Region"]; $main_place = $region_arr["Region"]; $page_type = "region"; } else { $city_arr = db_select("select * from cities where CountryID = '".$country_arr["CountryId"]."' and city_url like '".$_GET["place_url"]."'"); $city_arr = $city_arr[0]; $place["c"] = $city_arr["City"]; $main_place = $city_arr["City"]; $page_type = "city"; } } $keywords = array("Web development","Web design","Web development company","Business application software development","Mobile application software development","Web design company"); function get_combination() { global $place,$keywords; $place_rev = array_reverse($place); foreach ($place_rev as $p) foreach ($keywords as $k) $str .= $k." ".$p.", "; return $str; } $db_url_str = $_SERVER["REQUEST_URI"]; $content_cache_list = db_select("select * from content_cache where content_cache_url = '".$db_url_str."' and deleted = 'N' limit 0,1"); $content_para_ids = $content_cache_list[0]["content_para_ids"]; if ($content_para_ids == "") { $content_para_count_list = db_select("select content_para_id from content_para order by rand() limit 0,".rand(2, 4)); foreach ($content_para_count_list as $content_p_id) { $content_para_id_arr[] = $content_p_id["content_para_id"]; } $content_para_ids = implode(",",$content_para_id_arr); db_exec("insert into content_cache (content_cache_url, content_para_ids, dt_created) values ('".$db_url_str."','".$content_para_ids."', now())"); } $content_paras = db_select("select content_para_title, content_para_text from content_para where content_para_id IN (".$content_para_ids.") and deleted = 'N'"); $rand_countries_arr = db_select("select country_url, Country from countries order by rand() limit 0,5"); $rand_regions_arr = db_select("select region_url, Region from regions where CountryID = '".$country_arr["CountryId"]."' order by rand() limit 0,5"); $rand_cities_arr = db_select("select city_url, City from cities where CountryId = '".$country_arr["CountryId"]."' order by rand() limit 0,5"); $combination_keyw = get_combination(); ?> | Pegasus InfoCorp