Insert multiple random password into mysql

[Fareast Adam]

Here is my code:

[PHP]if(isset($_REQUEST['Generate']))
{
$nopwd= $_POST['nopwd'];//no of password
$length = $_POST['length'];//lenght of password
$value1= $_POST['pwdchar1'];//abcdefghijklmnopqrstuvwxyz
$value2= $_POST['pwdchar2'];//ABCDEFGHIJKLMNOPQRSTUVWXYZ
$value3= $_POST['pwdchar3'];//0123456789
$chars = $value1."".$value2."".$value3;

$max_i = strlen($chars)-1;

for($i=0;$i<$nopwd;$i++)
{
$newpwds = array();//array for random password
for($j=0;$j<$length;$j++)
{
$value[$i] .= $chars{mt_rand(0,$max_i)};
}
$newpwds[$i] = $value[$i];//insert new index into array
}
//insert into db all array index
for($x=0;$x<sizeof($newpwds);$x++)
{
mysql_query("UPDATE user SET password='".$newpwds[$x]."' WHERE accessLevel1='2' AND deptID='20'") or die(mysql_error());
}
}[/PHP]

Why all row ($nopwd) receives same random password (a value)?

[ronverdonk]

You have several errors in your code. Main is that you are (a) initializing the array each time (b) replace the same chars in the array, so your passwords are always identical. The first 'for' loop must be replaced with this code.
[php] $newpwds = array(); //array for random password
for($i=0; $i<$nopwd; $i++) {
$value="";
for($j=0; $j<$length; $j++) {
$value .= $chars{mt_rand(0,$max_i)};
}
$newpwds[] = $value; //insert new index into array
}[/php]
Ronald :cool:

[Fareast Adam]

Thanks Ronald for ur help but i still got same output. I try to split one by one code all went ok. I expect the mysql update code not running carefully coz when i just display an array index (without include update code) it running ok.

[PHP]for($x=0;$x<sizeof($newpwds);$x++)
{
echo "Password".(1+$x)." :\t".$newpwds[$x]."<br>";
}[/PHP]
Regard,
Fareast Adam