include '../config.php'; $adv = true; if (isset($_REQUEST['title'])) { $title = $_REQUEST['title']; $title = str_replace("-", " ", $title); } if (isset($_REQUEST['city'])) { $city = $_REQUEST['city']; $city = str_replace("-", " ", $city); } if ($title != 'Home') { if ($title != '') { $s_bg=mysql_query('SELECT * FROM mi_places_to_visit where city = "'.$city.'" and title = "'.$title.'" order by id limit 1',$link); } else { $s_bg=mysql_query("SELECT * FROM mi_places_to_visit where city = '".$city."' order by rand() limit 1",$link); } $s_bg1=mysql_fetch_array($s_bg); $id =$s_bg1['id']; $title =$s_bg1['title']; $country =$s_bg1['country']; $state =$s_bg1['state']; $description =$s_bg1['description']; $img1 =$s_bg1['img1']; $idNxt = $id+1; $s_bgNxt=mysql_query('SELECT * FROM mi_places_to_visit where city = "'.$city.'" and id = "'.$idNxt.'" order by id limit 1',$link); $s_bg2=mysql_fetch_array($s_bgNxt); $title2 =$s_bg2['title']; $titleN = str_replace(" ", "-", $title2); if ($titleN == '') { $s_bgNxt1=mysql_query('SELECT * FROM mi_places_to_visit where city = "'.$city.'" and id >= 1 limit 1',$link); $s_bg21=mysql_fetch_array($s_bgNxt1); $title21 =$s_bg21['title']; $titleN = str_replace(" ", "-", $title21); } $idPrv = $id-1; $s_bgPrv=mysql_query('SELECT * FROM mi_places_to_visit where city = "'.$city.'" and id = "'.$idPrv.'" order by id limit 1',$link); $s_bg3=mysql_fetch_array($s_bgPrv); $title3 =$s_bg3['title']; $titleP = str_replace(" ", "-", $title3); if ($titleP == '') { $s_bgPrv1=mysql_query('SELECT * FROM mi_places_to_visit where city = "'.$city.'" order by id desc limit 1',$link); $s_bg31=mysql_fetch_array($s_bgPrv1); $title31 =$s_bg31['title']; $titleP = str_replace(" ", "-", $title31); } } $HeadT = $city . " – ".$title ." | ". $country ." - ". $state ." | Chourishi Systems"; $HeadD = $country ." - ". $state .". Mobsea Mobile Web Apps, Android, iOS, Nokia, Blackberry, Mobile Applications."; ?> include '../header1.php' ?> if ($city != '') { ?>