include('dbconnect.php');
//SET UP PAGINATION
$limit = 30;
$query_count = "SELECT COUNT(*) AS numrows FROM news";
$result_count = mysqli_query($link,$query_count);
$row = mysqli_fetch_array($result_count);
$totalrows = $row['numrows'];
$page = $_GET['page'];
if(empty($page)) {
$page = 1; }
//PERFORM OUR QUERY
$limitvalue = $page * $limit - ($limit);
//SET UP QUERY
$query = "SELECT idnum, title, teaser, date_ent FROM news ORDER BY date_ent DESC LIMIT $limitvalue, $limit";
$records = mysqli_query($link,$query);
if(@mysqli_num_rows($records) == 0)
{
print "
No records found ";
}
else
{
//LOOP THROUGH TO MAKE THE TABLES FOR EACH NEWS ITEM
while($row = @mysqli_fetch_array($records))
{
//GET VARS WE NEED AND BUILD LINK
$idnum = $row['idnum'];
$title = stripslashes($row['title']);
$teaser = stripslashes($row['teaser']);
$date_ent = $row['date_ent'];
$link = "view.php?idnum=".$idnum."&category=news";
//take care of date for this entry
$month = date('m', strtotime($date_ent));
$day = date('d', strtotime($date_ent));
$year = date('Y', strtotime($date_ent));
$date = "$month/$day/$year";
print "
-
$date

