out put data range

[lankavision]

hello.

 

I hv a database named lankavis_webs and there is a table named sl_hits. The fied are in the table like this,

 

id, song, artist, bitrate, dowload_url, views, downloads, lyrics, datetime.

 

There are about 1000 records in the data table.

I want to get output rows as last 25 record in 1.php and next 25-50 from last in 2.php and go ahead like it.

Already i have made fecth arry to display data . But i want to know how to select rows range like above.

Please help me.