<?php 




	$filename = TOUR_ROOT."/freetour.php";
	$static_page = TOUR_URL."/tour/freetour.php";	 
	$page_name="../tour.php";
	
if(!isset($_GET["start"])) {                         // This variable is set to zero for the first page
$start = '0';
}else {$start = $_GET["start"];}
$eu = ($start); 
$limit = 4; // No of records to be shown per page.
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 

 $query = " SELECT distinct(a.asset_id),  a.media, a.user_def_id, t2m.model_id, DATE_FORMAT(a.p_date, '%m.%d.%Y') as show_date,   a.description, UNIX_TIMESTAMP(a.p_date) as f_date, a.photos_count, t.free_link, t.tour_description, t.tour_title, t.main_image 
FROM mod2vid t2m,assets a, tour t 
WHERE (t2m.asset_id = a.asset_id) and t.asset_id = a.asset_id   and  t.site_id = '".CURR_SITE_ID."' and  t.tour_date <= '".date('Y-m-d')."'  ".stripslashes($view_code)." and a.hide_photo <> 'y' and t.tour_title <> '' group by a.asset_id   order by t.tour_date desc"; 



$result2 = mysql_query($query);
	$row2 = mysql_fetch_assoc($result2)or die('main tour code error: ' . $query . mysql_error());

	$nume = mysql_num_rows($result2);

	$query .= " limit $eu, $limit";
	$result_main = mysql_query($query)or die('main tour error 2 : ' . $query . mysql_error());
	$num_result_main = mysql_num_rows($result_main);
	
	
	
?>