i want to display data from textnews field in mysql within limited lines. can any one

[deepakjadhav]

i want to display data from textnews field in mysql within limited lines. can any one help me. the data is in textnews field at 500 lines. i want to display only 25 lines per page. please help me

[Luuk]

Look at the the LIMIT and OFFSET options of SELECT

[adriancs]

thats right. for example:

select * from `tablename` limit 0,25;

the above sql means select all rows start from row 1 to row 25.