include('dbconnect.php');
//SET UP PAGINATION
$limit = 30;
$query_count = "SELECT COUNT(*) AS numrows FROM press";
$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 press 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 ROWS
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'];
$date = date('m/d/Y', strtotime($date_ent));
$link = "view.php?idnum=".$idnum."&category=press";
print "
-
$date
$teaser

