Hi All,

I just wanted to know how to not show the text entered in a field I considered is a password field by using phpMyAdmin.

I am using php to insert the fields from a page to the MySql database.

Thank u for ur response in advance.

SL

Do you mean not show it inside the form field (just show dots or stars instead)? if that is it then just set your form field type to type="password"

hth ~megan

Thank u Megan. But thats not what I want. Ofcourse if u do that in a text box, what u type on the password field will be invisible. What I want is: to make invisible (I mean replace it with a dot or astrix just like its on the text box whose type is set as password) or hide the text in the field I assumed is a password field in MySql table. (When looking at it by opening the table.)

I have seen a "Password" function when I use the PhpMyAdmin insert to table option. But I dont know how to use it in conjunction with Sql statement embeded in PHP statements.

Cheers,
SL

Ok... i think you have to explain that again in a simple and clear method....

Are you saying this.

You have a table in MySQL table with a password column.

When for example your displaying the results of a table, do you want the password but in complete invisible state? So you cannot see the input field but there is a field holding a value?

If so, its - <input type=hidden value=$table['password']>

I thank you all for the effort you have made to understand the problem I have and help me out.

I have managed to solve the problem. MySQL has a function called password ( PASSWORD('{$HTTP_POST_VARS['txtPassword']}') ) to decrypt the text given and store it in the MySQL database. So even if somebody has access to the database and tries to see the user passwords saved in the table, he/she cant (simple security ah?).

Thank you all again

That was it... Md5 works too...