gistfile1.php

<txp:php>
// <?
// build a list of file categories
$rs = safe_query('select distinct category
                  from ' . safe_pfx('txp_file') . '
                  order by category asc', 1);
if ($rs)
{
    while ($row = mysql_fetch_array($rs, MYSQL_NUM))
    { 
        $cat = $row[0];
        echo "<h2>$cat</h2>", 
        file_download_list(array('category' => $cat,
                                 'break' => '',
                                 'limit' => 999));
    }
}
</txp:php>