<?
include("config.inc.php");
$output = '';
$result = mysql_query("SELECT id, title, type, size, artist, year, persing, quality, colour, code, label, amount, comments, cover FROM albums");
    while( $row = mysql_fetch_array($result) )
    {
        $typeq = mysql_query("SELECT * FROM type WHERE id='".$row[2]."' ");
        while($typea = mysql_fetch_assoc($typeq))
            {
                $typeo = $typea[type];
            }
            $sizeq = mysql_query("SELECT * FROM size WHERE id='".$row[3]."' ");
            while($sizea = mysql_fetch_assoc($sizeq))
            {
                $sizeo = $sizea[size];
            }
            $artistq = mysql_query("SELECT * FROM artist WHERE id='".$row[4]."' ");
            while($artista = mysql_fetch_assoc($artistq))
            {
                $artisto = $artista[artist];
            }
            $qualityq = mysql_query("SELECT * FROM quality WHERE id='".$row[7]."' ");
            while($qualitya = mysql_fetch_assoc($qualityq))
            {
                $qualityo = $qualitya[quality];
            }
            $labelq = mysql_query("SELECT * FROM label WHERE id='".$row[10]."' ");
            while($labela = mysql_fetch_assoc($labelq))
            {
                $labelo = $labela[label];
            }
            $output .= <<<__HTML_END
            <div id='showalbum'>
            <div id='showcover'><img src='/covers/tb_$row[13]'></div>
            <div id='showdata'>
            <table>
            <tr><td>Title:</td><td>$row[1]</td></tr>
            <tr><td>Artist:</td><td>$artisto</td></tr>
            <tr><td>Type:</td><td>$typeo</td></tr>
            <tr><td>Size:</td><td>$sizeo</td></tr>
            <tr><td>Quality:</td><td>$qualityo</td></tr>
            </table>
            </div>
            </div>
__HTML_END;
        }
echo $output;
?>