mysql rand not working, always getting same result
===

I have this MYSQL query :

        while ($x <= 9) {
       $data_1 = "SELECT scene FROM star WHERE star LIKE '%".$star."%' ORDER BY RAND() LIMIT  1";
       //
       $result_1 = mysql_query ($data_1)
        OR die("Error: $data_1 </br>".mysql_error());
       while($row_1 = mysql_fetch_object($result_1)) {
       
        $scene = $row_1->scene;
        
        $x = $x + 1;
       } 

I want to get everytime a new scene for each executation, but I always get the same scene. Whats the issue? Can someone make me a few pointers in which direction I have to search ? 