title: How i display my database list using pagination in php
body: <p>php file . i have more then 50 records in my mysql database so i need to display those records using pagination .. so kindly give me solution for me ., i have no idea about pagination ... </p>
  
  <p>display.php</p>
  
  <pre><code>    &lt;?php
  include('connect.php');
  $sql = "select * from member_table ORDER BY id DESC limit 0, 8 ";
  $retain = mysql_query($sql, $con);
  if (!$retain)
  {
  die ('no add posted yet' .mysql_error());
  }
  while($row = mysql_fetch_array($retain))
  {
  echo "id: {$row['id']}&lt;br&gt;".
       "Title:{$row['title']}&lt;br&gt;".
       "Description:{$row['description']}&lt;br&gt;".
       "Image:{$row['file']}&lt;br&gt;&lt;br&gt;&lt;br&gt;";
  }
  echo "you can view only last few adds";
  ?&gt;
  </code></pre>
  
  <p>the above code shows all the records is single page .
  kindly guide me how to display using paging in php
  Thanks a lot in advance .........</p>