Dám sem celý kod který to zobrazuje:
<?php
define('DB_CHARSET', 'CP1250');
require "settings.php";
?>
<?php
/// stránkování
$stranka=isset($_GET['stranka']) ? (int)$_GET['stranka'] : 1;
$limit=5;
$start=($stranka -1)*$limit;
// /stránkování
$albs=Array();
$pocetAlb=0;
If(isset($_GET['interpret'])) {
$where="WHERE Contentgroup='".mysql_real_escape_string($_GET['interpret'])."'";
$interpretQ='&interpret='.RawUrlEncode($_GET['interpret']);
}
Else {
$where='';
$interpretQ='';
}
$q=MySQL_Query("SELECT (SELECT COUNT(Album) FROM (SELECT * FROM country $where GROUP BY Album) p) AS pocet,Album FROM country $where GROUP BY Album LIMIT $start,$limit") or die(mysql_error());
While($r=MySQL_Fetch_Assoc($q)) {
$albs[]=mysql_real_escape_string($r['Album']);
$pocetAlb=$r['pocet'];
}
$query = "SELECT Title,Artist,Album,Track,Year,Length,Composer,Filename,Albumartist,Genre,Contentgroup FROM country WHERE Album IN('".(Implode("','",$albs))."') ORDER BY Album ASC,Track ASC";
$results = mysql_query($query) or die(Mysql_error());
$aktAlbum='';
$i=0;
$a=0;
While($result=MySQL_Fetch_Assoc($results)) {
$lastResult=$result; // uchová poslední výsledek v proměnné (pro výpis Vydavatele u posledního alba)
If($aktAlbum!=$result['Album']) {
If($aktAlbum!='') {
$a++;
?>
</tbody>
</table>
<h3>Vydavatel:</h3>
<div class="oddelovac"> </div>
<?php } ?>
<h1 onclick="hideshow(<?=$a?>)"><?php echo htmlSpecialChars($result['Album'],ENT_QUOTES); ?></h1>
<h3><?php echo htmlSpecialChars($result['Artist'],ENT_QUOTES); ?></h3>
<h3><?php echo htmlSpecialChars($result['Year'],ENT_QUOTES); ?></h3>
<?php print "\t\t" . '<img width="100" height="100" src="/images/' . $result['Album'] .'.jpg">' . "\n"; ?>
<table width="100%">
<thead>
<tr><th><a href=""><img src="img/download.png" width="150" height="50" alt="Download" /></a></th></tr>
<tr>
<th class="title">Track</th>
<th class="title">Title</th>
<th class="title">Artist</th>
<th class="title">Genre</th>
<th class="title">Composer</th>
<th class="title">Length</th>
<th class="title">Filename</th>
</tr>
</thead>
<tbody>
<?php
$aktAlbum=$result['Album'];
$i=0;
}
$i++;
?>
<tr class="<?=($i%2?'lichy':'sudy')?>">
<td align="center"><?php echo htmlSpecialChars($result['Track'],ENT_QUOTES); ?></td>
<td><?php echo htmlSpecialChars($result['Title'],ENT_QUOTES); ?></td>
<td><?php echo htmlSpecialChars($result['Artist'],ENT_QUOTES); ?></td>
<td><?php echo htmlSpecialChars($result['Genre'],ENT_QUOTES); ?></td>
<td><?php echo htmlSpecialChars($result['Composer'],ENT_QUOTES); ?></td>
<td><?php echo htmlSpecialChars($result['Autor'],ENT_QUOTES); ?></td>
<td><?php echo Str_Pad(Floor($result['Length']/60),2,'0',STR_PAD_LEFT).':'.Str_Pad($result['Length']%60,2,'0',STR_PAD_LEFT); ?></td>
<td><?php echo htmlSpecialChars($result['Filename'],ENT_QUOTES); ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
<h3>Vydavatel:</h3>
<div class="oddelovac"> </div>
<div id="strankovani">
<?php
for($s=1;$s<=Ceil($pocetAlb/$limit);$s++)
echo "<a href=\"?stranka={$s}{$interpretQ}\">$s</a> ";
?>
</div>
</div>