I have newbie question.

I am building a search page that will return any number of records and want
to display only 30 at a time say.  Then have one of though "Page 1 of 3  [1]
[2] [3] Next>" on top of the record list.

What is the best way to do this.

I was looking at using the LIMIT feature in MySQL, but the MySQL manual said
that if you use ORDER BY with LIMIT in the same SELECT it does the LIMIT
before the ORDER BY.  Therefore it does the limit then orders the limit list
only, not order the entire list then returns the limit from that.  Is this
This it better to retrieve the entire record list, then jump to a starting
position.  Say on Page 2 start displaying at record 31.

If I use the second method, is there a PHP/MySQL function of move to a
certain record.

I know there is probably many different solution to this problem, but what
are some of them.  I was going to use my last option but if I have a 1000+
records loading each time the performance may be slow.

Thanks, Mark.
Mark McCulligh, Application Developer / Analyst
Sykes Canada Corporation www.SykesCanada.com

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to