weddingm - 5:58 pm on Mar 9, 2011 (gmt 0)

I am creating a random song showing from db. I have the song, artist and lyrics in 3 different fields in same db. How do I put that in the array?


$songquery="SELECT * from songdb WHERE lyrics !='NONE'";
$songqueryresult=mysql_query($songquery);
while($songrowdata=mysql_fetch_array($songqueryresult))
{ $song=$songrowdata['song'];
$artist=$songrowdata['artist'];
$lyrics=$songrowdata['lyrics'];


$songs[] = $dbsongs

srand ((double) microtime() * 1000000);
$randomsong=rand((0,count($songs)-1);

echo "<p>" . $songs[$randomsong] . "</p>";
}


Thanks,
Matt