You'll want to use LIMIT and OFFSET. $query = "select id from picture limit 10 offset $_GET[offset]";
Just have your previous and next change the value of offset and have it encoded into the link. Here's a link: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT -Brent On Mon, 2003-07-07 at 12:03, Adrian Madrid wrote: > Is there a library of some sort to batch queries? I > mean, to have something like first, second, third, > etc. 10 rows of 250. Like, > > Records (x - x) out of x > << View Previous 10 - View next 10 >> > > Any ideas/pointers? I don;t even know if batching is > the right name. > > Thanks, > > > > > ===== > ----------------------------- > Adrian Esteban Madrid > HyperXMedia, Developer > ================ > > ____________________ > BYU Unix Users Group > http://uug.byu.edu/ > ___________________________________________________________________ > List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
