By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,814 Members | 1,671 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,814 IT Pros & Developers. It's quick & easy.

"<<previous<< 2 3 4 5 >>next>>" scheme

P: n/a
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

Aug 28 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Also sprach hSiplu:
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.
You could use MySQL's LIMIT clause.
Aug 28 '06 #2

P: n/a
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

Aug 29 '06 #3

P: n/a
oh
I have found it !
limit [offset,] row_count
that solves everything :)

Aug 29 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.