updating every row with random password script

[SVB]

Hey. Im trying to get a lot of a membership script finished, and theres a few things still need doing. This part im having problems with. Ive imported 750 records from a CSV file to an SQL database. These records hae been assigned random usernames and passwords. However, the passwords need to be MD5'd. So what I need to do is add an md5'd password to every user in the database, and email each individual their own password (the non-md5 one). The problems im haing is that i can never get it to work properly. It either updates everyone with the exact same password, or it updates 1 person, or it doesnt do anything. Please help!
I need some sort of loop to run the update query in, make any random password, add the password in MD5 form to the first record, email the non md5 password to that records email, and repeat the loop for the next record, producing a new unique password. The records dont have any type of auto_increment ID, so it will need to be done some other way. Any ideas?
I currently have the following, but theres no loop or anything to add a unique password to eeach record in the table
[code:1:d67bcc65a1]
<?php
include("database.php");
$randpass= rand();
$query = "UPDATE users SET password = md5('$randpass') "
$query2 = "SELECT * FROM users";
$result = mysql_query($query) or die(mysql_error());
$result2 = mysql_query($query2) or die(mysql_error());
while ($row = mysql_fetch_array($result2)) {
mail($row["email"],"password $pass username $username)
}
?>
[/code:1:d67bcc65a1]
That code updates every record with the same password. i need it to update every record in turn with an individual password, and email that person right after it updates with their non-md5'd password.

[hatchet]

Take this
$randpass = rand();
$query = "UPDATE users SET password = md5('$randpass')";
and place into the while statement.

[SVB]

But i want a different random password to be placed in every row of the table

[hatchet]

Yep. Everytime it loops <b>while</b> there are still results it will reset the $randpass variable. Whats between { } after while, gets done for each new result.

[SVB]

[code:1:9acd7105f5]
<?php
include("database.php");

$query2 = "SELECT * FROM users";

$result2 = mysql_query($query2) or die(mysql_error());
while ($row = mysql_fetch_array($result2)) {
$randpass= rand();
$query = "UPDATE users SET password = md5('$randpass')";
$result = mysql_query($query) or die(mysql_error());
/*mail code goes here*/
echo $row["email"] . "<BR>Username: " . $row["username"] . "<BR>Password: " . $randpass . "<BR><BR>";
}

?>
[/code:1:9acd7105f5]

I did that. In the echo bit at the end, its fine, it echo's a different random password for eceryone. However, the update query has updated everyone with the same md5 password.

[kwvarga]

use this

[code]<?php
include("database.php");

$query2 = "SELECT * FROM users";

$result2 = mysql_query($query2) or die(mysql_error());
while ($row = mysql_fetch_array($result2)) {
$randpass= rand();
$user = $row['username'];
$query = "UPDATE users SET password = md5('$randpass') WHERE username = '$user'";
$result = mysql_query($query) or die(mysql_error());
/*mail code goes here*/
echo $row["email"] . "<BR>Username: " . $row["username"] . "<BR>Password: " . $randpass . "<BR><BR>";
}

?>

[SVB]

Thank alot for the quick reply Spear, Im trying to get this done ASAP. Ill try that code now

[SVB]

It works :-) Thanks man