Encrypting Passwords

[SP8600]

Could some one please tell me how i can md5 this password variable.

$sql = "UPDATE users SET password='$password' WHERE ID='$id'";

[capbiker]

This is the easy way of doing it:-

$password = md5($password);

And then add it to the database, using your query of which you have posted.

So your coding should look like:-

$password = md5($password);
$sql = "UPDATE users SET password='$password' WHERE ID='$id'";

[bretticus]

If you're using MySQL, as I assume, you can use the md5 function within your query command also:

$sql = "UPDATE users SET password=MD5('$password')  WHERE ID='$id'";