Random numbers to DB

[magnetica]

Whats wrong here because this works but edits all the rows and not specific and if i put a where clause in then it doesnt work at all.

 

$result = mysql_query("SELECT * FROM videos");



	while($row = mysql_fetch_array($result)){
	$rand1 = rand(60,125);

		mysql_query("UPDATE `a8129045_central`.`videos` SET thumbs_up = '$rand1'");


	}

[ignace]

mysql_query("UPDATE `a8129045_central`.`videos` SET thumbs_up = '$rand1'");

 

Updates each and every row meaning all rows will get the last random number given. Use:

 

$id = $row['id'];
mysql_query("UPDATE `a8129045_central`.`videos` SET thumbs_up = '$rand1' WHERE id = '$id'");