database password structure in phpmyadmin

[AbydosGater]

Hey, i was just wondering for my users table in my database when i go into phpmyadmin and set the structure for the password field to password, it encrypts all the passwords in the table,
But what method of decryption do i use for the script that needs the password? md5, base_64??


Thanks

[.josh]

you would refer to it in your query as for example:

[code]
$user = 'someuser';
$pass = 'somepassword';
$sql = "select * from table where user='$user'  and pass = password('$pass')";
[/code]

and there is no way to 'decrypt' it and show it as normal lettering.

[AbydosGater]

Oh ok! Thanks