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. > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php