|
|
379dischi recensiti |
208artisti presenti |
la musica cristiana...è qui! |
|
|
|
1000000000 AND MX_albums.formazione = MX_formazioni.id".
" AND MX_albums.pubblicato = 1".
//" AND MX_albums.copertina = 1".
" AND MX_albums.uscita > ".(date(Y,time())-3).
" ORDER BY MX_albums.uscita DESC, MX_albums.id DESC LIMIT 20";
$queryrnd = "SELECT * FROM (".$query.") AS QUERY2 "." ORDER BY RAND() LIMIT ".$totale;
$result = mysql_query($queryrnd) or die ("Errore nella richiesta: $query. " .mysql_error()); while($row = mysql_fetch_array($result))
{
//if ( $totale < ($righe * 2) )
{
$exclude = $exclude." AND MX_albums.id <> ".$row['id'];
if ( $conto == 1 ) { $bordo = " style=\"border-right: thin dotted #cccccc;\""; } else { $bordo = ""; }
echo "\t\t\t\t\t".
"\t\t\t\t\t\t". "\t\t\t\t\t\t\t \r\n". "\t\t\t\t\t\t\t ![\"".$row['titolo']."\"](\"".immagine($row['id'],"mini","produzione")."\") ".
"\t\t\t\t\t\t\t\t".charactersfill($row['commenti'],$accorcia).
"\t\t\t\t\t\t\t
".
"\t\t\t\t\t\t | \r\n\t\t\t\t \r\n\t\t\t\t\r\n";
}
}
$conto++;
$totale++;
}
?>
|
|
|
1000000000 AND MX_albums.formazione = MX_formazioni.id".
/* " AND MX_albums.uscita <> 0 AND MX_albums.pubblicato = 1 AND MX_albums.promozione = 1 ".$exclude.
*/
" AND MX_albums.uscita <> 0 AND MX_albums.pubblicato = 1 ".$exclude.
/* " ORDER BY promozione DESC, MX_albums.copertina DESC,RAND() LIMIT ".($righe * 2) ; $result = mysql_query($query) or die ("Errore nella richiesta: $query. " .mysql_error()); while($row = mysql_fetch_array($result))
*/
/* " ORDER BY MX_albums.uscita DESC LIMIT ".($righe * 2).") b ORDER BY b.uscita_disco DESC";
*/
" ORDER BY MX_albums.id DESC LIMIT ".($righe * 4).") b ORDER BY b.uscita_disco DESC";
$queryrnd = "SELECT * FROM (".$query.") AS QUERY2 "." ORDER BY RAND() LIMIT ".($righe * 2);
$result = mysql_query($queryrnd) or die ("Errore nella richiesta: $query. " .mysql_error());
while($row = mysql_fetch_array($result))
{
//if ( $conto == 1 ) { $bordo = " style=\"border-right: thin dotted #cccccc;\""; } else { $bordo = ""; }
echo "\t\t\t\t\t".
"\t\t\t\t\t\t". "\t\t\t\t\t\t\t ".$row['nome']."".
//"\t\t\t\t\t\t ". "\t\t\t\t\t\t\t ".
/* "\t\t\t\t\t\t\t\t".charactersfill($row['commenti'],$accorcia).
*/
" ".
"".$row['titolo']."
\r\n".
//
(".$row['uscita'].")
"\t\t\t\t\t\t\t\t".$row['editore']."
";
//$durata = $row['durata'];
$querybrani = "SELECT COUNT(id) FROM MX_brani WHERE MX_brani.album=".$row['id'];
$resultbrani = mysql_query($querybrani) or die ("Errore nella richiesta: $querybrani. " .mysql_error());
$brani = mysql_result($resultbrani, 0);
if ($brani > 0)
echo $brani." brani";
/*if ($row['durata'] == "00:00:00")
echo " ";
else {
if ($brani > 0)
echo ", ";
echo $durata;
}*/
echo "\t\t\t\t\t\t\t".
"\t\t\t\t\t\t ";
if ( $conto == 2/*$righe*/ )
{
$conto = 0;
echo "\t\t\t\t\t | \r\n\t\t\t\t \r\n\t\t\t\t\r\n";
}
$conto++;
}
?>
scopri le novità discografiche
|
| |
|
|