January,'2'=>February,'3'=>March,'4'=>April,'5'=>May,'6'=>June,'7'=>July,'8'=>August,'9'=>September,'10'=>October,'11'=>November,'12'=>December); if(array_key_exists($fmnth,$month)) { $festmnth = $month[$fmnth]; } $title = stripslashes($row[3]); $description = stripslashes($row[4]); $keywords = stripslashes($row[5]); if($row[7]!='0'){ $sqlc = "SELECT tc.*,ts.State_Name as State,tr.Tag_Name as Region FROM tbl_CityConfi tc inner join tbl_State ts on tc.State_Id=ts.State_Id inner join tbl_TagConfi tr on tc.Region_Id = tr.Tag_Id where tc.CityC_Id = '$row[7]' "; $resultc = mysql_query($sqlc); $rowc = mysql_fetch_row($resultc); $region = $rowc[6]; $cityn = $rowc[3]; $state = $rowc[5]; } $brief = stripslashes($row[10]); $tname = unserialize($row[12]); $ttitle = unserialize($row[11]); $tdes = unserialize($row[13]); $text1 = unserialize($row[14]); $text2 = unserialize($row[15]); $stext = unserialize($row[16]); $seq = unserialize($row[18]); $fseq = array_flip($seq); $countf = count($fseq); ksort($fseq); $images = unserialize($row[17]); $flipseq = array_flip($seq); $keyseq = array_keys($flipseq); $flipkey = array_flip($keyseq); ksort($flipkey); $cityfid = $row[7]; $sqlitn=mysql_query("Select Itinerary_Id,Itinerary_City from tbl_Itinerary where `Status`='Active' "); $arrayitn=array(); while($rowitn = mysql_fetch_array($sqlitn)) { $itid=''; $cities = unserialize($rowitn['Itinerary_City']); $itid = $rowitn['Itinerary_Id']; foreach($cities as $acity) { $scity=''; $scity = substr($acity,1); $sqlfcty=mysql_query("Select City_Id,City_Name from tbl_City where `Status`='Active' and `City_Id`='".$scity."'"); $rowfcty = mysql_fetch_row($sqlfcty); $flcity = $rowfcty[1]; if($flcity==$cityfid){array_push($arrayitn,$itid);} } } $arrayitn = array_unique($arrayitn); /*session_start(); $_SESSION['pageid'][]="f".$fid; $arrayre = array_unique($_SESSION['pageid']);*/ $server = $_SERVER['HTTP_HOST']; $festn1 = preg_replace('/\s+/', '%20', $festn); ?> <?php echo $title; ?> "; } echo $datam;?>
'.$text1[$fseq[$j]].'
'.$text2[$fseq[$j]].'
'.$stext[$fseq[$j]].'
'; } echo $divt; ?>

Location

Related Itineraries

"; for($k=$i;$k<($i+2);$k++) { if(!empty($arrayitn[$arrayintk[$k]])){ $sqlitny = "Select Itinerary_Id,Itinerary_Name,Image,Sequence,Itinerary_Url from tbl_Itinerary where `Status`='Active' and `Itinerary_Id` = '".$arrayitn[$arrayintk[$k]]."' "; $resultny = mysql_query($sqlitny); $rowitny = mysql_fetch_row($resultny); $image = unserialize($rowitny[2]); $seq = unserialize($rowitny[3]); $server = $_SERVER['HTTP_HOST']; $flipseq = array_flip($seq); $keyseq = array_keys($flipseq); $flipkey = array_flip($keyseq); ksort($flipkey); $fimg = $image[$flipkey[1]]; $namei = preg_replace('/\s+/', '%20', $rowitny[1]); $nameni = htmlspecialchars($namei); $datat .="
"; $datat .=" ".$namei.""; $datat .="

".$rowitny[1]."

"; $datat .="
"; } } $datat .="
"; $j++;} echo $datat;?>