[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>";
}

?>