[Resolved] Data Values too long

Aybabtu

So in my super database making I made a mistake. It can be fixed to work normally but I was wondering how you would take a 25 charcter value and only take the first 10 charcters. The problem is that I made a password feild in the database only 10 charcters and when I put the md5 atribute to a value I stored in there it makes it much longer than 10 but only puts the first 10 in and clips the rest. so now when I query with a 25 charcter string in a 10 charcter feild.

If I confused you, sorry but I need some help.

pjleonhardt

please dont double post

Aybabtu

I looked around and I tried the following:

$passencrypt = md5($_POST["password"]);
$pass = str_split($passencrypt, 10);

This did not work, I dont consider this a double post when what I have looked at does not work. Please offer any help you can or at least let me know why this wont work.

pjleonhardt

what I meant by dont double post is that you created two threads asking the same thing...

and substr() should work here..

Example:


$pass = md5($_POST['password'];
$pass = substr($pass, 10);

you could also do it your way, but you have to realize that when you do str_split it returns an array, each element being 10 characters long.

so you would do:

$passencrypt = md5($_POST["password"]); 
$passarray = str_split($passencrypt, 10);
$pass = $passarray[0];

Aybabtu

Thanks for all the help. I didn't realize that this was double posted. I was having problems posting the first one and it just sat there doing nothing... So I tried another post and it worked right away. Oh well thanks again.