RE: [PHP] selcet statement question

[snip] I know that i can retrieve records 1-24 in my db with a select statement like SELECT whatever FROM tablename ORDER BY id ASC LIMIT 23, but how can I get records 25 to 50 if I have 100 records in my DB? [/snip] Different DB's have differing ways of doing this, like MySQL; SELECT * FROM foo ORDER BY id ASC LIMIT 0, 24 ****** first 25 records SELECT * FROM foo ORDER BY id ASC LIMIT 25, 24 ***** next 25 records Don't forget that the row numbering starts with 0. HTH! Jay "Oh, sure…but what’s the speed of DARK?" ************************************* * Want to meet other PHP developers * * in your area? Check out: * * http://php.meetup.com/ * * No developer is an island ... * *************************************