Array with Mysql

Question

I’m trying to make a draw of songs but it always displays the last song registered in the database

$sql = "SELECT nome FROM CadMusicas"; 
$result = mysql_query($sql, $conecta); 


while($consulta = mysql_fetch_array($result)) { 
   $antigos= array($consulta[nome]);
   $numMusicas= sizeof($antigos);
   # Primeiro ganhador
   $sorteado[1] = $antigos[rand(0,$numMusicas- 1)];
} 


echo "<b>Musicas Sorteadas:</b> <br />";
echo "<b>1°</b> - " . $sorteado[1] . "<br />";

Answer 1

I believe the best thing to do is to use the RAND.

SELECT nome FROM CadMusicas ORDER BY RAND()

This will return the records in a random order, it will depend on how your database is structured, each song must be a 'line'!

If it’s just a record, do it:

$sql = 'SELECT nome FROM CadMusicas ORDER BY RAND() LIMIT 1';

$result = mysql_query($sql, $conecta); 

$consulta = mysql_fetch_array($result);
echo $consulta['nome'];

Note: RAND performs terribly poorly in large banks but one solution is to use this:

SELECT nome FROM CadMusicas WHERE RAND()<(SELECT ((1/COUNT(*))*10) FROM CadMusicas) ORDER BY RAND() LIMIT 1