SELECT * FROM tbl WHERE this=that limit 1,10; SELECT * FROM tbl WHERE this=that limit 11,10; SELECT * FROM tbl WHERE this=that limit 21,10; SELECT * FROM tbl WHERE this=that limit 31,10;
etc etc etc... syntax: limit [start row],[# of rows to return] To get a total first do a COUNT(*) on the first page and store it in a session var so you don't need to do it over and over again. Hope that helps. Serge. ----- Original Message ----- From: "Lukas Liebenberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 28, 2002 1:05 PM Subject: Problem with found rows > Hi > > I need to retrieve records (10 at a time) for a search engine type site. > > This will be quite easy using MySql V4 (SQL_CALC_FOUND_ROWS and FOUND_ROWS) > but I only have access to V3.23 > > Any help pleeaase > > Lukas > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
