md5 encryption and database prob

mateo1221

THIS CODE:

<?php

include("include/connect.php");

$query = "SELECT password FROM members WHERE id_no = 2002081107";

$result = mysql_query($query, $connect);

$myarr = mysql_fetch_array($result);

$insert = md5($myarr[password]);

$query2 = "INSERT INTO members (password) VALUES (" . $insert . ") WHERE id_no = 2002081107";

$result2 = mysql_query($query2, $connect);

$query3 = "SELECT password FROM members WHERE id_no = 2002081107";

$result3 = mysql_query($query3, $connect);

$myarr3 = mysql_fetch_array($result3);

echo "new_value = " . $insert . "<br>";

echo "from_database = " . $myarr3[password];

IS GENERATING THIS OUTPUT:

new_value = 5b4c6f05e39f90fcebd51be99338c42e
from_database = mateo

THE OUTPUT I WANT IS:

new_value = 5b4c6f05e39f90fcebd51be99338c42e
from_database = 5b4c6f05e39f90fcebd51be99338c42e

WHAT I WANT IT TO DO IS CONVERT THE STRING PASSWORD IN THE DATABASE INTO AN ENCRYPTED PASSWORD!!! HOW DO I GET IT TO DO SO? HAVING MAJOR ISSUES SO FAR!!! 😕 HELP! HEHE, THANKS IN ADVANCE!

dnszero

Your problem is due to your INSERT statement. You need to use UPDATE instead (insert only allows new records, will not change existing ones).

But you'd prolly be better off altogether to store your passwords encrypted in the first place with the mysql function MD5().

mateo1221

gotcha... the problem is more complex than that... i'm using password to access the database, but i can't insert the password that way... it's goofy (makes sense to me... i promise) i'm doing it the way you described, i just need to set up ONE account this way so that the rest can be set up with MY login/pw... if that makes sense... anyway, thx for your help... UPDATE works fine... thx!