PHP Paging

I am having a doubt in PHP paging,,, i think most of the php programmers aware of paging,,

i checked lots of php paging tutorials and i did not found what i want

all tutorials deals with just selecting all data from database and displaying them by breaking up into pages, but i don't want that,,,,

i want tutorial for these methods,

1. select some number of data, and want to break them into page,

for eg, if database has 1000 data, i want to select only first 100 data and break them into page,,,

2. select all data from database and show the result as search engine shows, eg, Google,, first it shows 1 - 10 links, when i click 10, it will show 11,12,13, etc.,

i can't find tutorials for these,, please help me with this

 

this http://www.php-mysql-tutorial.com/wikis/php-tutorial/paging-using-php.aspx should help u to some extent

 

How To Create A Pagination In PHP

http://www.jooria.com/PHP-Pagination-a125.html

Code (markup):

 

for 100 result per page: on first page just do "select * from something limit 0,100"

on next page do something like "select * from something limit 100,100"

on each page just calculate new 'start index' for select statement and that's it