Back on http://www.php-scripts.com/php_diary/1/09/2001.php3, I showed people how to make a simple counter using a flat file data system and over time this has proven to be one of the more popular diary entries (by reader rating) that I've ever written. One thing you couldn't do with that particular script was to have more than one counter (unless you modified it considerably). So what if one wanted to have counters on multiple pages on the website using one script? Today let's create a script to do this using mySQL. The first thing we need to do is plan out our mySQL table structure.

Pre-article Note: In the hosting business and in my own site enterprises, I've run across hundreds of scripts that make life easier for webmasters. Unfortunately, all the scripts on my own sites have usually been programmed by myself and currently are not for sale. This article will reference to scripts that have certain uses on sites but will not name them specifically as I don't know where to find most of them. Please refer to the forums and other articles on this site for help finding them. I'll help you with the ones I'm familiar with and I'm sure someone else can help you find all the others.

To this day, I still have some friends that update their sites by hand. Where they spend 3 hours a day updating portions of their site, I may spend 30 minutes or less. My content posting script allows the posters to enter all the relevant information. It automatically takes out all the duds and then I just go through and approve the content that I like. I can either change what the poster entered or leave their information on the page. My script rotates the page at the same time everyday, I even have a countdown to when it will be updated, along with the number of updates coming. The script checks all the content throughout the day for bad links and will remove them automatically. All the variables are customizable, from the number of submissions to display on the page to how many submissions one person can make.