MSSQL/PHP - Picking every row

[Linear88]

Is there a way to pick every row of a column: Password
and replace the values of that picked row to its own value but hashed (md5)?

I think it would need PHP for a script involving MSSQL/ODBC.

[MentaL]

[own_prox]

<?PHP

mssql_connect ('','','');
mssql_select_db ('GunzDB');
$accounts = 0;
$query = mssql_query (sprintf ("SELECT * FROM Login"));
while($row = mssql_fetch_array($query))
{
$accounts += 1;
mssql_query (sprintf ("UPDATE Login SET Password = '%s' WHERE Password = '%s'", md5($row['Password']), $row['Password']));
echo $accounts;

}

?>

[Linear88]

Thanks a lot!

[Guy]

<?PHP

mssql_connect ('','','');
mssql_select_db ('GunzDB');
$accounts = 0;
$query = mssql_query (sprintf ("SELECT * FROM Login"));
while($row = mssql_fetch_array($query))
{
$accounts += 1;
mssql_query (sprintf ("UPDATE Login SET Password = '%s' WHERE Password = '%s'", md5($row['Password']), $row['Password']));
echo $accounts;

}

?>

Why the hell would sprinf be required either time? PHP has it's own method of combining strings.