Miscellany

<?php
require 'news/connect.php';

if(isset($_GET['page'])) {
    $page = (int) $_GET['page']; // this makes sure the page is a number, to save you from SQL injection
    $limit = ' LIMIT  '. ($page -1) * 3 .' , 3 ';
}
else {
    $limit = " LIMIT 3";
}

$query = "SELECT title, news, admin, date FROM news ORDER BY id DESC $limit ";
$result = mysql_query($query);
$r = 2;
while($r=mysql_fetch_array($result))
{
    $title=$r["title"];
    $news=$r["news"];
    $admin=$r["admin"];
    $date=$r["date"];
    echo "<b> $title <br></b>Posted on: $date, by: $admin <blockquote>$news</blockquote>
             ";
}
?>