title: php pagination for mysql result
body: <p>I know m asking it again maybe but i tried the questions available on pagination but couldnt understand dem properly ... need to know the way to paginate the results of the following query : </p>
  
  <pre><code>$query = "SELECT * FROM info WHERE Cat1 = 'novel'";
  $result = mysql_query($query);
  if (!$result) die ("DAtabase acces faild bc : ". mysql_error());
  
  echo " &lt;ul class=listbkwide2&gt;";
  
  while($data = mysql_fetch_object($result))
  {
  $id = $data-&gt;id;
  $name = $data-&gt;Bname ;
  $continent = $data-&gt;Bauthor;
  
      echo "  &lt;li class=bkd&gt;&lt;a href='details.php?bid=$id'&gt; 
           &lt;img src='images/sbs/$name.jpg'  title='$name' alt=''&gt;
        &lt;ul class=showcasetitle&gt; &lt;span&gt; $name &lt;/span&gt; &lt;/ul&gt;
         &lt;p class=authname&gt; By    &lt;span&gt; $continent&lt;/span&gt;&lt;/p&gt;  
        ";
  }
  echo " &lt;/ul&gt; ";
  ini_set('display_errors', '1');
  mysql_close();
  </code></pre>