Sorry I can't see anything wrong with your syntax. I tried redoing most of what you have done and it worked fine (though I didn't match the table structure exactly it was close).
**EDIT - I see you already answered this***
So if you just go select * from user you can see the record in the table ?
What if you try select * from user where userid='xxxx' ?
I now think the problem might be that you made a mistake typing the original insert query.
When I insert password('xxxx'); the hashed result is 5a62d73531da5605 which doesn't match what you have.
Hey - thanks.
Originally Posted by cranial-bore
I got it.
When setting up the database i created the password column like this...
password char(16) not null.
When I ran my query, the return value was 41 digits long, but the password in the db was clipped to 16. So I changed to
password char(41) not null.
I think 41 digits maybe a bit overlkill for what I'm trying to do, so to save some database space I think I will try to work out how to clip the userinput hashed value to 16.
Thanks alot and g'day