php...encryption of column...need info.

[boyzdynasty]

I want to create a column in a table.
but I want the column to be encrypted...how do I do that....(it's for the password)

And if I were to retrieve the column, how do I unencrypt it?


*using PHP to manipulated mySQL DB*

Thanx!!

[boyzdynasty]

never mind.

i need to encrypt the password b4 I inserted in the table.
That was it.

[CyanBlue]

Show us what your script look like... I think some people might be benefitted from it... Of course, if you don't mind... ;)

[boyzdynasty]

nothing fancy...just use the encryption method (md5) that is built into mySQL

Ex:
====
INSERT INTO employee (ssn,password,title,firstName,lastName,address,cit y,state,zip,phone,status,dateHired,dateTerm,commen ts) VALUES("123456789",md5("whatever"),"MA","TOM","TESTER","123 FAKE STREET","PHILADELPHIA","PA","19122","1234566543","1","20030310", "","");


but when you check for password...for authentication...you have to convert the password input from the user using md5($password) first...then do the query