I am new to PHP. I am trying to do a simple user login page with MySQL as the database to store names and passwords. I was wondering what field type to use in conjunction with the password MySQL function.
I would suggest VARCHAR(40). That should be plenty of space for a password using the MySQL PASSWORD() function. I did the same thing in a program of mine using MD5() for encryption. MD5() returns a string of 32 hexadecimal digits.
HTH, Rodney