Freetag is an easy tagging and folksonomy-enabled plugin for use with MySQL-PHP applications. It allows you to create tags on existing database schemas, and access and manage your tags through a robust API.
Although "tagging" is often promented as an alternative to organization by a hierarchy of categories, more and more online resources seem to use a hybrid system, where items are organized into broad categories, with finer classification distinctions being