Re: mysql LIMIT
| From: | Robert Cummings | Date: | Sun, 14 Jul 2002 21:10:54 +0000 |
| Subject: | Re: mysql LIMIT | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-107638@lists.php.net to get a copy of this message | ||
Alexander Ross wrote:
>
> can I use limit to show the 2nd record on without knowing how many more
> records there might be?
>
> also, what happens if I set the limit in a mysql statement (LIMIT 5,10), but
> there are only 3 results? 7 results?
This looks like a question that could be answered with a 10 second test
query!
Cheers,
Rob.
--
.-----------------.
| Robert Cummings |
:-----------------`----------------------------.
| Webdeployer - Chief PHP and Java Programmer |
:----------------------------------------------:
| Mail : mailto:robert.cummings@webmotion.com |
| Phone : (613) 731-4046 x.109 |
:----------------------------------------------:
| Website : http://www.webmotion.com |
| Fax : (613) 260-9545 |
`----------------------------------------------'