Select * from yourTable limit 0,5
gets you the first 5. After that:
Select * from yourTable limit 5,5
gets you the next five...etc.
Cal
http://www.calevans.com
-----Original Message-----
From: Tyler Longrne [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 6:33 PM
To: MySQL List
Subject: Select in groups of 5
Hello everyone,
Is there any way to make selections in groups of 5. I want to get 5 record
sets at a time until we get to a point that there's 4 or less records.
Thank you everyone,
Tyler
database,sql,query,table
---------------------------------------------------------------------
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
