Re: odd results inquiry
| From: | Michael J. Pawlowsky | Date: | Fri, 27 Dec 2002 03:44:10 +0000 |
| Subject: | Re: odd results inquiry | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-129410@lists.php.net to get a copy of this message | ||
Actually I bet if you take a closer look at your code you will see that your are incrementing
that value somewhere before the query is executed or something.
Perhaps you are mixing up the order of the row limit and starting point.
The 0 is right.
I just quickly tried it in a mysql term
SELECT id, pid from tree limit 0,3;
SELECT id, pid from tree limit 3,3;
SELECT id, pid from tree limit 6,3;
*********** REPLY SEPARATOR ***********
On 26/12/2002 at 10:32 PM Michael J. Pawlowsky wrote:
>Well the second one I can help you with.. it should be LIMIT 11,10 if you
>only want 10 rows.... You are asking for 20.
>For the fun of it try 1,10 on the first one.
>
>