if ($gid!="" && is_numeric($gid)) { echo replaceChars(getGenreById($gid),false); } ?>
if ($gid!="" && is_numeric($gid))
{
for ($a=0;$a<27;$a++)
{
if (hasArtistes($gid,$alp[$a]))
{
?>
- echo strtoupper($alp[$a]); ?>
} // if hasArtistes
else
{
?>
- echo strtoupper($alp[$a]); ?>
} // else (if hasArtistes)
} // for a
} // if gid && is_numeric
?>
if ($gid!="" && is_numeric($gid))
{
if ($page!="" && is_numeric($page))
$seek = ($page-1)*16;
else $seek = 0;
if ($alpha!="" && strlen($alpha)==1)
$myquery = "SELECT albums.id,albums.medium FROM albums INNER JOIN artistes ON albums.artiste=artistes.id WHERE albums.genre='$gid' AND LOWER(LEFT(artistes.nom,1))='$alpha' ORDER BY artistes.nom LIMIT $seek,16";
else $myquery = "SELECT albums.id,albums.medium FROM albums INNER JOIN artistes ON albums.artiste=artistes.id WHERE albums.genre='$gid' ORDER BY artistes.nom LIMIT $seek,16";
$result = mysql_query($myquery,$mycon);
$nba = mysql_num_rows($result);
if ($nba>0)
{
for ($a=0;$a<$nba;$a++)
{
$q_id = mysql_result($result,$a,"albums.id");
$q_medium = mysql_result($result,$a,"albums.medium");
?>
" alt=" echo replaceChars(getDatasAlbumById($q_id,"nom"),false); ?>" width="76" height="76" />
} // for a
} // if nba
} // if gid && is_numeric
if ($alpha!="" && strlen($alpha)==1)
$myquery = "SELECT albums.id FROM albums INNER JOIN artistes ON albums.artiste=artistes.id WHERE albums.genre='$gid' AND LOWER(LEFT(artistes.nom,1))='$alpha' ORDER BY artistes.nom";
else $myquery = "SELECT albums.id FROM albums INNER JOIN artistes ON albums.artiste=artistes.id WHERE albums.genre='$gid' ORDER BY artistes.nom";
$result = mysql_query($myquery,$mycon);
$totala = mysql_num_rows($result);
if ($totala>0)
{
$nbpages = ceil($totala/16);
?>
Page:
if ($page<=1)
{
?>
- Précédante
}
else
{
?>
- &p= echo $page-1; ?>">Précédante
}
for ($p=0;$p<$nbpages;$p++)
{
if ($page==($p+1))
{
?>
- echo $p+1; ?>
} // if page
else
{
?>
- &p= echo $p+1; ?>"> echo $p+1; ?>
} // else (if page)
} // for p
if ($page>=$nbpages)
{
?>
- Suivante
}
else
{
?>
- &p= echo $page+1; ?>">Suivante
}
?>
} // if totala
?>