[SOLVED] Mysql Problem

[xshanelarsonx]

I'm trying to randomly pick a row from a mysql table and display it's info. I keep getting a error on line 2.

 

$Music="SELECT * from songs ORDER BY RND() LIMIT 1";
$Music_Result=mysql_query($Music);
while ($row=mysql_fetch_array($Music_Result))
{
$SongNameRandom=$row["SongName"];
$FileRandom=$row["File"];
}

[Jessica]

It helps to know which line is six.

 

The mysql keyword is rand, not rnd.

$Music_Result=mysql_query($Music) or die(mysql_error()); would give you a better error.

[The Little Guy]

Its RAND, not RND

[xshanelarsonx]

Its RAND, not RND

 

Thank you, this fixed it.

 

Thanks Jesirose for pointing that out. For now on I'll tell what row it is with that code, I was using the whole page when it told me that row. LOL