[SOLVED] Problems with updating a table

[Richzilla]

I'm trying to create a script to input into one of my pages that does a calculation and adds it to a new coulmn. I can't get teh code to cycle through all the values in the database. So far it's just done the first row.

 

Here's the code

$query = "SELECT * FROM Mixes";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
while ($i < 'num') {
$id=mysql_result($result,$i,"id");
$rating_total=mysql_result($result,$i,"total_votes");
$rating_number=mysql_result($result,$i,"total_voted");
if ($rating_total != 0){
$rating = $rating_total / $rating_number;
}?>
<?
$query = "UPDATE * Mixes SET rating = '$rating' ";
$result=mysql_query($query);
$i++;
}
mysql_close();
?>