Pulling content from a MySQL database is one thing, but formatting those results is something compeltely different. A lot of the time, when you pull data out, you have quite a sizeable chunk, and you need a quick and painless way to split it up for easy consumption. Well, this new article from DevShed might have an answer.

For all those out there that need it, Paginating MySQL Data with PHP gives you a great starting place for breaking up the data you recieve back. The basic idea here is to use the MySQL keyword LIMIT to help you grab the results, instead of pulling them all out and trying to store them somehow. This not only makes it easier to get the information you need, but there's less data moving back and forth.

It's a pretty good piece, especially for those that need a "quick and dirty" way to get the job done. Keep in mind, though, that there's always more than one way to do things, so if this method doesn't work for you, then there's lots of other ways...