mysql - How i display my database list using pagination in php -

this question has answer here:

• simple php pagination script [closed] 3 answers

php file . have more 50 records in mysql database need display records using pagination .. kindly give me solution me ., have no idea pagination ...

display.php

    <?php include('connect.php'); $sql = "select * member_table order 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']}<br>".      "title:{$row['title']}<br>".      "description:{$row['description']}<br>".      "image:{$row['file']}<br><br><br>"; } echo "you can view last few adds"; ?> 

the above code shows records single page . kindly guide me how display using paging in php lot in advance .........

i hope sql example helped you:

select * customers limit 100

you can page through results this:

select * customers limit 1000.50

return 50 records starting 1000