\n"; echo "

Clásicos

\n"; echo "
"; echo "
"; $sql = "CREATE TEMPORARY TABLE IF NOT EXISTS tmp AS SELECT * FROM disco_clasico WHERE fecha <= CURDATE() ORDER BY RAND() LIMIT 50"; $consulta = mysql_query($sql); $sql = "SELECT * FROM tmp ORDER BY grupo"; $consulta = mysql_query($sql); while($registro = mysql_fetch_assoc($consulta)) { echo ""; mysql_fetch_assoc($consulta); } echo "
"; echo "
"; $sql = "SELECT * FROM tmp ORDER BY grupo"; $consulta = mysql_query($sql); mysql_fetch_assoc($consulta); while($registro = mysql_fetch_assoc($consulta)) { echo ""; mysql_fetch_assoc($consulta); } echo "
"; echo "
"; echo "\n"; $sql = "DROP TABLE IF EXISTS tmp"; $consulta = mysql_query($sql); create_footer(); ?>