trying to get a certain num of rows in mysql

From: Date: Sat, 12 Oct 2002 22:43:35 +0000
Subject: trying to get a certain num of rows in mysql
Groups: php.general 
Request: Send a blank email to php-general+get-119747@lists.php.net to get a copy of this message
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?

« previous php.general (#119747) next »