<?
    // lib/abbr.php -- abbreviations and acronyms

    /*
    table: abbr
    +--------+------------------------+-----+---------+----------------+
    | Field  | Type                   | Key | Default | Extra          |
    +--------+------------------------+-----+---------+----------------+
    | aid    | smallint(5) unsigned   | PRI | NULL    | auto_increment |
    | tag    | enum('acronym','abbr') |     | acronym |                |
    | abbr   | char(8)                |     |         |                |
    | phrase | char(64)               |     |         |                |
    +--------+------------------------+-----+---------+----------------+
    */

    function abbr_hash()    {

        global $db;
        $_s = 'select tag, abbr, phrase from abbr';

        if ($_r = mysql_query($_s, $db))   {
            while (list($t, $a, $p) = mysql_fetch_row($_r))    {
                $_a[$a] = '<' . $t . ' title=" ' . $p . ' ">' . $a . '</' . $t . '>';
            }
            mysql_free_result($_r);
            return $_a;
        }
        return false;
    }

    $abbr = abbr_hash();

    // lib/abbr.php
?>