Check if record exists in mysql

[qwick0]

Ok, This seems like it should be simple, but I cannot for the life of me figure it out.  What I am doing is selecting a random value from a mysql table, and then inserting that value into another table.  However, I need to check to make sure the random value i pulled has not already been used.  I can only randomly select a Value 1 time.  This is the code i put together, but its messy and doesnt work lol.  There are a few random echo's in there, but thats just because i was trying to track what was going on.  Ignore them.

 

function select_song(){
$squery= "Select Song FROM Songs WHERE Final=0 ORDER BY rand()";
$sresult = mysql_query($squery) or die (mysql_error());
$srow = mysql_fetch_array($sresult, MYSQL_ASSOC);
$song=$srow["Song"];
if (song_check($song)){
	select_song2();
	return $song;}
	else{
	return $song;}
}

function song_check($song){
 $query = "SELECT Song FROM Expert WHERE Song = '$song'";
 $result = mysql_query($query) or die (mysql_error());
 $num = mysql_num_rows($result);
	if ($num > 0){
	echo "<br>$num<br>";
	return TRUE;
 	}else{
 	return FALSE;
 	}
  }

[sspoke]

ya its cool but whats the error

[JasonLewis]

is the $num variable being echoed?

[qwick0]

Oh the problem is that it does not work lol.  I made that.  Yes, $num is echoed.  I wasnt sure if maybe there was a simple way to do a "loop until" type setup?

[qwick0]

OK, i figured things out.  I was making it waaaaay more complicated than it needed to be.  I just made a while loop and said do while the song is repeated.  SO that way it would keep selecting a new song until it couldnt find it already existing.