Account Creation help

[nickelo]

My account creation is messed up. It works, it implements into the DB but apparently the Encrypt_Password is messed up, if I delete it. and execute

 update accounts set encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)))

it works. Anyone know the command to have it encrypt correctly in PHP? Anyone who helps gets a rep cookie =P

[Lukas 45]

rightclick on your Account table. Select Design table. Now make a new, where threre are 6 colums(Name, Type, Length, Decimals, Allow Null, Key)
Values: encrypted_password, varchar, 42, 0, off, off)
Now do so it are number 4(Acct, Name, Pass, Enc_Pass)(Dont know about that matter)

[TheSpidey]

No, don't remove random columns from your table. That's never good.

OP:
sha1( strtoupper($username) . ":" . strtoupper($password) );

[Lukas 45]

I dont say to REMOVE a colum, but create on

[nickelo]

i got it..command was pwencrypt lmfao =P i didn't know my db had 1