50)) { $limit = 7; //default } if((!$subpage) || (is_numeric($subpage) == false) || ($subpage < 0) || ($subpage > $total_items)) { $subpage = 1; //default } $p = ''; if(isset($_REQUEST['year'])) { $query = "SELECT * FROM news WHERE LOCATE('".$_REQUEST['year']."', date) ORDER BY date DESC"; $rs = $db->GetAll($query) or die("Error in query: " . $query . $db->ErrorMsg()); if(count($rs) == 0) { // paranoid $p .= '

We are sorry but we found no news items that you requested.

'; } else { // count($rs) > 0 $total_items = count($rs); $total_pages = ceil($total_items / $limit); $set_limit = ((int)$subpage * (int)$limit) - (int)$limit; $p .= '
'."\r\n"; $p .= '
'."\r\n"; $p .= '

News Archive

'."\r\n"; $p .= '
'."\r\n"; $p .= '
'."\r\n"; $p .= '

'.$set_limit.'There are ' . $total_items . ' news item(s) matching your criteria.

'."\r\n"; $p .= '
'."\r\n"; $p .= '
'."\r\n"; if((isset($set_limit)) && (isset($limit)) && ($set_limit > 0)) { $query = "SELECT * FROM news WHERE LOCATE('".$_REQUEST['year']."', date) ORDER BY date DESC LIMIT $set_limit, $limit"; } else { $query = "SELECT * FROM news WHERE LOCATE('".$_REQUEST['year']."', date) ORDER BY date DESC LIMIT 0, $limit"; } $newrs = $db->GetAll($query) or die("Error in query: " . $query . $db->ErrorMsg()); for($x = 0; $x < count($newrs); $x++) { $month = array('01'=>'January','02'=>'Febuary','03'=>'March','04'=>'April','05'=>'May','06'=>'June','07'=>'July','08'=>'August','09'=>'September','10'=>'October','11'=>'November','12'=>'December'); $date = explode(" ", $newrs[$x]['date']); $date = explode("-", $date['0']); $i = $date['1']; $month = substr($month[$i], 0, 3); $y .= ' ' . $month . ' ' . $date['0'] . ''. $newrs[$x]['title'] .'view more...'."\r\n"; $y .= '
'."\r\n"; $news = explode("\r\n", $newrs[$x]['news']); for($i = 0; $i < count($news); $i++) { if(empty($news[$i])) { $y .= ''; } else { $y .= '

'.$news[$i].'

'."\r\n"; } } $y .= '
'."\r\n"; if($newrs[$x]['img'] != NULL) { $y .= ' ' . $newrs[$x]['imgText'] . ''."\r\n"; } if($newrs[$x]['img2'] != NULL) { $y .= ' ' . $newrs[$x]['img2Text'] . ''."\r\n"; } $y .= '
'."\r\n"; $y .= '
'."\r\n"; } $p .= $y; $p .= '
'."\r\n"; $p .= '
'."\r\n"; // show page links if(count($rs) > $limit) { $p .= ''."\r\n"; } // show pages /*$p .= '
'."\r\n"; $p .= '

Page ' . $current_page . ' of ' . $total_pages . '

'."\r\n"; $pge = 1; $next=0; while ($pge <= $total_pages and $total_pages > 1) { $link = '' . $pge . ''; if ($pge < $total_pages) { $link .= ' | '; } $p .= $link; $pge++; $next += ($limit); }*/ echo $p; } } else { $query = "SELECT * FROM news n, user u WHERE n.uID = u.uID ORDER BY n.nID DESC LIMIT 0, 7"; $rs = $db->GetAll($query) or die("Error in query: " . $query . $db->ErrorMsg()); ?>

Latest News

'January','02'=>'Febuary','03'=>'March','04'=>'April','05'=>'May','06'=>'June','07'=>'July','08'=>'August','09'=>'September','10'=>'October','11'=>'November','12'=>'December'); for($x = 0;$x <= count($rs) - 1; $x++) { ?> view more...
'.$news[$i].'

'."\r\n"; } } echo $p; ?>
'."\r\n"; } if($rs[$x]['img2'] != NULL) { echo '' . $rs[$x]['img2Text'] . ''."\r\n"; } ?>