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 true? -OR- 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 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
