Look at limit... eg Select * from xyz limit 1,5
Timothy Hitchens (HITCHO)
HITCHO has Spoken!
From: Pablo Oliva [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 13 October 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: [PHP] trying to get a certain num of rows in mysql
When doing a select query, is there any way to specify which rows you
want "selected", as in rows 1 through 40, and then 40 - 80 on the next
query. I've been searching through the manual but can't find anything.
Should this be done through a php script instead, or is there a native
(mysql) command/clause for this?
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php