updating mysql table with random element from array

[rbarnett]

I have a user table that holds email addresses and for testing purposes I am trying to replace every email address with an email address defined in an array.  I would like to randomly choose an email address from the array and update the table with this address.  When I run the following code it randomly chooses a email address from the array but then updates every row with this one email address.  Can you someone please let me know what I am doing wrong.  Thanks in advance.

 

$query = "SELECT * FROM user '";
$result = mysql_query($query);

$input = array('email1', 'email2', 'email3', 'email4', 'email5', 'email6', 'email7');
$rand_keys = array_rand($input, 2);
$replaceStr = $input[$rand_keys[0]];

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$rand_keys = "";
$rand_keys = array_rand($input, 2);
$replaceStr = $input[$rand_keys[0]];

mysql_query("UPDATE user SET email = '$replaceStr'");

}

[freelance84]

mysql_query("UPDATE user SET email = '$replaceStr'");

 

You need to specify the user:

 

mysql_query("UPDATE user SET email = '$replaceStr' WHERE user='what ever the reference to the user field is' ");

 

[rbarnett]

Thank you!  That makes perfect sense.

 

I added $i = 1; before the while loop and $i++ inside the while loop and added where id = $i to the update query.

 

That works.  I really appreciate your help.