shows the record added;
but when I do
select count(*) from users where passwd=MD5('test');
shows 0 (no record)
Why???
Care to show your code so that we can see exactly what it is doing?