Limiting results to X number of rows
| From: | CDitty | Date: | Sun, 02 Jul 2000 17:45:58 +0000 |
| Subject: | Limiting results to X number of rows | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-4377@lists.php.net to get a copy of this message | ||
Does anyone know of a way to limit the mysql return results to X number of rows? In Oracle, I use rowcount < 10, but I can't use this in Mysql.
The only way I can think to do this is to do a select then subtract the number I want from the total. Then in the select statement I need it in, select * from table where id > previous_select.
Any tips?
CDitty