Random show from db from 3 fields

need help showing array

[weddingm]

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

[topr8]

you could change your sql to:

SELECT * from songdb WHERE lyrics !='NONE' ORDER BY RAND()

this will return songs in a random order.

it is not the most efficient way of doing it but assuming you don't have 10's of thousands of songs it will be fine

[weddingm]

Ok thanks I will give it a try.

[weddingm]

I just can't quite get it working. The following code shows all the songs instead of just 1 ?

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

$songs[]="".$song."<br />".$artist."<br /><a href='http://www.sample.com/".$lyrics."'>Lyrics</a>";
 
srand((double) microtime() * 1000000);
$randomsong=rand(0, (count($songs)-1));

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

[brotherhood of LAN]

Add "LIMIT 1" to the end of the query

[dev.mysql.com...]

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants (except when using prepared statements).

[weddingm]

Thank you brotherhood. Works great. Now we'll see if the song changes tomorrow.

[rocknbil]

Umm . . . it may not. :-) Random can often pick the same record. What you need to do is store a "viewed" value somewhere, so that it only picks from those not viewed in the most recent random go 'round. When they are all used up, reset viewed to 0 and pick again.

select count(*) from table where viewed = 0;

if ($count == 0) {
update table set viewed=0;
}

.... now do your random ....

select id, title from table where viewed=0 order by rand limit 1;

update table set viewed=1 where id=$id;