A purpose-built PHP and MySQL system runs this large database system, containing details of over 550 past-pupils from a school on the outskirts of London.

Ex-pupils can add themselves to the public list using a form which includes some comprehensive error checking to ensure sensible entries.

Entries are then verified by sending the ex-pupil an email with a password which must be entered on the site before their entry becomes "public"; this ensures the email address given is genuine. Once verified in this way, ex-pupils appear on the public list. Users can edit their entries at any time and choose a memorable password.

The system runs without any administration required. Emails are sent to the administrator to inform when events such as adding and editing occur. Another feature is a messaging system which allows pupils to receive messages via the site without disclosing their email address.

A search facility is also included which will search by name or location or joining/leaving year. The list of past-pupils can be ordered in a number of ways - for example year of joining, or first name - and either ascending or descending.

The site is very popular with the school's past-pupils and is a good example of the way PHP and MySQL can be integrated to show vast amounts of information in an ordered and simple fashion.