More PHP/SQL help

[benjy355]

Sorry about last time, I didn't know about this forum

Would anybody know an SQL query or php action I could use to make a SQL table in password format into normal text again? (For login's and such)

Edit:
Let me explain this more better, let's say you insert a table into your database and set it's function to PASSWORD

$query = "INSERT INTO `MyTable` (`MyRow`, `MyOtherRow`, `MyBoolean`) VALUES
(PASSWORD('MyValue'), 'AnotherValue', '1');";

Now I want to select that table and get 'MyRow' without it being encoded with with the PASSWORD function.
Any ideas?

 

[mad]

http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_password

PASSWORD() encryption is one-way (not reversible).

 

[benjy355]

>_>... md5() it is then.

(I forgot to post that I got the answer to my question, md5 )