[SOLVED] Noobie MySQL Question

[notepad]

Hey,

 

I am working on a users script using MySQL and PHP. I am pretty good with PHP, but am very new with MySQL... I have the passwords (among other things) set to a max length. I would like to set the max length of characters to the same number in the database. From what I understand, if I set a row to "varchar (30)", that row will record a maximum of 30 characters. Is this correct?

 

~ Brandon

[freakstyle]

yep, your correct. varchar 30 means the field will only hold 30 characters.

 

for passwords, you may want to set the field to varchar 32, and then encrypt them... ex: $pw = md5($_POST['password']);

that way no one knows what it is.

 

enjoy

 

[notepad]

Hey freakstyle,

 

Thanks for the info man... I have been searching all over Google trying to figure this out, and never found anything lol...

 

btw, another good thing to do to your passwords is to salt them. That way no one can figure them out unless they have your salt key.

 

~ Notepad