ORDER BY RAND ** SQL Issue

From everything I can tell, my syntax is right, but this is not working:

$result3 = mysql_query("SELECT threeva FROM partthree ORDER BY RAND() LIMIT 7");
$row3 = mysql_fetch_array($result3);
  echo $row3['threeva']."<br /><br />";

Code (markup):

The above will just pull 1 random value. There are about 20 values to choose from but it doesn't matter what I set the LIMIT as, it will only produce 1 result.

Any suggestions?

 

$result3 = mysql_query("SELECT threeva FROM partthree ORDER BY RAND() LIMIT 7");
while ($row3 = mysql_fetch_assoc($result3){
echo $row3['threeva'].'<br /><br />';
}

PHP:

 

THANKS a ton! Worked like a charm! +rep.

 

Glad I could help. This will work with almost any mysql_query that needs to data from multiple rows to be outputted, btw.