Straight from the Horse's Mouth.
Dec 4, 2006:
I have chosen to use a Blog to clearly demonstrate how PHP and MySQL can be used to display the contents of a database. The MySQL database on the server stores the Title, Article, Dates, Image and Caption for each Blog entries and assigns them a unique ID number.
All databases are effectively created from a blank sheet of paper, so the chosen content to store and display is infinately variable. Our Blog also illustrates how the database can be used to track the dates of stored and updated entries. 
We have chosen to display the Blog as Short and Long Extracts over an expandable second page. Much the same way as you would get the first few lines of a catalogue or news entry and click a link to a different page to show the full version.
The images for the Blog are kept outside of the database in a seperate folder held on the server, so all that needs to be stored in the database is the image filename and a caption to use as alternative text.
The Blog, Gallery and Quotation databases can all be amended and updated via a user friendly interface that we construct to run in any web browser. Knowledge of MySQL or PHP is not required to add or amend the content of the databases and effectively alter the website for future upgrades.
Last Updated: 7:11 PM on Jan 23, 2009