As a PHP and MySQL Developer I browse around many forums and one of the more common questions being asked is 'How do I Add Next / Prev Links to my Pages?'. Even I asked this very question a long time ago when I was beginning to learn PHP. I decided to write this article because despite learning how to do this myself, I never really found a decent article on the Internet that was geared more towards a beginner and that was suitable for PHP Installations that are now configured with Register Globals Off.
I have attempted to write an article that explains even the basic areas, that walks through every line of the code explaining what it does and why it is there, so this is what I have attempted to do with this article. Hopefully by the time you reach the end you will feel confident enough to write your own code without even using this article as a reference guide.
The article is based on a MySQL database and assumes a basic knowledge of constructing SQL Queries. I will go through connecting and disconnecting from the database and some other clauses and statements. This should be fairly easy to port to other database platforms if required.