>next>>" scheme "/>

"<>next>>" scheme

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
hi all,
I am creating a web project with php/mysql.
one of qeury result is too high. it returs several thousand rows.
But I can't show them in one page.
So I wanna create more than one pages
then I shall use "<<previous<< 2 3 4 5 >>next>>" scheme.
but i don't have any idea.
If user clicks 3rd page. I shall show the 3rd page.
How should I do this ?
should I again query the whole or a portion ? what is the function
related to this.
Thank in advance

Re: "<>next>>" scheme

Also sprach hSiplu:

Quoted text here. Click to load it

You could use MySQL's LIMIT clause.  

Re: "<>next>>" scheme

if I use
select * from t1 limit 10;
it shows first 10 returned rows.
It wont work.  
it would work if an range could be used

Re: "<>next>>" scheme

I have found it !
limit [offset,] row_count
that solves everything :)

Site Timeline