cant update mysql table with over 10000 records

vcvcv

New Member
My code is here\[code\]$query = "SELECT * FROM `table`";$result = mysql_query($query); $arr = array(); while($info = mysql_fetch_array($result)) { if (!in_array($info['row'], $arr)) { $arr[] = $info['row']; } }foreach ($arr as $v) { $pass = "pass";$query2 = "UPDATE `table` SET pass = '$pass' WHERE row = '$v'";$result2 = mysql_query($query2);}\[/code\]it processes for 2 minutes and nothing happens in db. where could i be wrong ?ThanksEDIT: OK i found my mistake. It was about the code that i wrote for generating random pass which i didnt include in my question. thanks everybody thou
 
Back
Top