Ejemplo de lista de archivos

$query = query("SELECT *, COUNT(name) AS howmuch FROM files, properties WHERE id = fileid GROUP BY name ORDER BY howmuch DESC");
while($row = mysql_fetch_array($query)){
    $name = $row['name'];
    echo '<h2>'.$name' '.$howmuch.' repeticiones </h2>';
    $query2 = query("SELECT * FROM files,properties WHERE name = '$name' AND fileid = id ORDER BY fileid DESC");
    while($row2 = mysql_fetch_array($query2)){
        echo '&nbsp;&nbsp;'.$row2['loquequierasguachín'].'<br/>';
    }
}