<?php 
$niche_id = $_GET["niche_id"];
	
$show_message = 'n'; 

	$query = "SELECT niche_name   ";
	$query .= "FROM niche ";
	$query .= "where niche_id = '".$niche_id."' ";
	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
	$row = mysql_fetch_assoc($result);
	$niche_name = $row["niche_name"];

	$title_add = $niche_name;
	$niche_name_nospace = str_replace(' ', '', $niche_name);
	
	$put_dir = TOUR_ROOT."/niche/$niche_name_nospace";
	$filename = $put_dir."/".$niche_name_nospace.".php";
	$static_page = TOUR_URL."/tour/niche/$niche_name_nospace/$niche_name_nospace.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 = 5; // 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, DATE_FORMAT(a.p_date, '%m.%d.%Y') as show_date,  a.title, a.description, UNIX_TIMESTAMP(a.p_date) as f_date, t.free_link, t.tour_description, t.tour_title 
FROM assets a, niche2asset n2a , tour t 
WHERE  (n2a.asset_id = a.asset_id)  and t.asset_id = a.asset_id and  t.site_id = '".CURR_SITE_ID."' and a.hide_photo <> 'y' and t.tour_title <> ''  and n2a.niche_id = '".$niche_id."'  group by a.asset_id order by t.tour_date desc";
// and t.tour_date <= '".date('Y-m-d')."'



$result2 = mysql_query($query);
$nume = mysql_num_rows($result2);

	$row2 = mysql_fetch_assoc($result2)or die('<br />The darn code makes an error: ' . mysql_error());
	

	
	$media = $row2["media"];
	$asset_id = $row2["asset_id"];
	$f_date = $row2["f_date"];
	$free_link = $row2["free_link"];


	$query .= " limit $eu, $limit";
	$result_main = mysql_query($query)or die('The porn is so toasty it is creating an error: ' . mysql_error());
	$num_result_main = mysql_num_rows($result_main);
	
	$top_img_dir = TOUR_ROOT."/images/niche/".$niche_id;
	$url_dir = TOUR_URL."/images/niche/".$niche_id;
	

?>