'NULL' $searchWhere AND update_date <= CURDATE()") or die(mysql_error());
$rcr = mysql_fetch_array($result_count);
$total_results = $rcr['count'];
}
if ((($page * $max_results)-$max_results) > $total_results)
{
$page = 1;
}
$from = (($page * $max_results) - $max_results);
$q = "SELECT * $addQuery FROM tour_updates tu LEFT JOIN content c ON c.record_num = tu.main_record WHERE record_num <> 'NULL' $searchWhere AND update_date <= CURDATE() ORDER BY $orderby LIMIT $from,$max_results";
//echo "$q
";
$result = mysql_query($q) or die(mysql_error());
$total_pages = ceil($total_results / $max_results);
//$total_pages = "12";
$pages = array();
$max_pages = "12";
/*
include("./tour_includes/header.php");
$see_more_link = "./updates.htm?nats=".$natsCodeInclude;
//for($i = 1; $i <= $total_pages; $i++)
for($i = 1; $i <= $max_pages; $i++)
{
if($i == 1) { $link = '1'; } else { $link = $i; }
if ($i > $total_pages)
{
$pages[] = '
'. $i .'';
}
elseif(($page) == $i)
{
$pages[] = ''. $i .'';
}
else
{
$pages[] = ''. $i .'';
}
}
$current_page = "./updates.htm?nats=".$natsCodeInclude;
if ($page > 1)
{
//$current_page = "updates.htm";
$current_page = "./updates_$page.html?nats=".$natsCodeInclude;
}
$next_page = "https://join.over40handjobs.com/signup/signup.php?nats='.$natsCodeInclude.'&step=2";
if ($page < $total_pages)
{
//$next_page = "updates.htm";
$next_page = "./updates_".($page+1).".htmll?sort=$sort&nats=".$natsCodeInclude;
}
*/
$current_page = "updates.htm";
if ($page > 1)
{
$current_page = "updates_$page.html";
}
$showPages = "8";
$pageSplit = $page > ceil($showPages/2) && $page < ($total_pages-ceil($showPages/2))? ceil($showPages/2):$showPages;
$pageStart = 0;
$pageEnd = $total_pages;
$pageStartInc = 0;
include("./tour_includes/header.php");
$end_link = 'Next';
for($i = 1; $i <= $total_pages; $i++)
{
$pageName = $i > "1"? 'updates':'tour';
if(($page) == $i)
{
$pageStart = $i-$pageSplit > 0? ($i+$pageSplit < $total_pages? $i-$pageSplit:$total_pages-$pageSplit):0;
$pageEnd = $pageStart > 0? ($i+$pageSplit < $total_pages? $i+$pageSplit:$total_pages):$pageSplit;
$pages[] = ''. $i .'';
}
else
{
$pages[] = ''. $i .'';
}
}
$nextPage = $page < $total_pages? 'Next':'Next';
$previousPage = $pageStart > 0? 'Prev':'';
$see_more_link = $page < $total_pages? './updates_'. ($page+1) .'.html?nats='.$natsCodeInclude.'':"./updates.html?nats=".$natsCodeInclude;
?>
Next Over40Handjobs Update
0)
{
while($row = mysql_fetch_array($result))
{
echo '
Date: '. date("F j, Y",strtotime($row['scheduled_date'])) .'
'. $row['length'] .' HD Video / '. $row['num_pics'] .' Pictures
'. $row['update_description'] .'
';
}
}
?>