error in pagination code

See more:

Javascript

PHP

jQuery

paging

hello friends,

I am facing following error in my pagination script please help me to solve this.

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\lib\author\data.php on line 16

following is my script


db.php

<?php
mysql_connect("localhost","root","");
mysql_select_db("library");
?>

data.php

<?php

include('../db.php');
if($_GET['page'])
{
    $page =$_GET['page'];
}
$per_page_num=2;
$offset = ($page-1)* $per_page_num;
$getdata = ("select * from author limit $offset,1");
$checking = mysql_query($getdata);
//if($checking=== FALSE) {
 //   die(mysql_error()); // TODO: better error handling
//}

while ($rows = mysql_fetch_array($checking))
{
    ?>

    <?=$rows['name']?><br/>
    <?php
}
?>

delt.php

<?php
include("../db.php");

$query = mysql_query("select * from author");
$count = mysql_num_rows($query);
$per_page=1;
$total = ceil($count/$per_page);
?>
<ul id="paginate">
    <?php
    for ($i=1;$i<=$total;$i++)
    {
        ?>
        <li id="<?=$i?>"><?=$i?></li>
    <?php
    }
    ?>
</ul>
<div id="content"></div>
<div id="load"></div>
<script src="../jquery.js" type="text/javascript"></script>
<script>
    $(document).ready(function(){
        function display(){
            $("#load").fadeIn("slow");
            $("#load").html('<img src="https://themarketingoak.files.wordpress.com/2015/07/circle-loading-animation.gif">');
        }
        function hide(){
            $("#load").fadeOut(3000);
        }
        $("#paginate li:first").css({color:"red"});
        display();

        $("#content").load('data.php?page=1',hide());
        $("#paginate li").click(function(){
           display();
            $("#paginate li").css({color:"blue"});
            $(this).css({color:"red"});
            var num=$(this).id;
            $("#content").load('data.php?page='+ num,hide());
        });
    });
</script>