CREATE TABLE users(
userid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30),
password VARCHAR(20),
email VARCHAR(220)
);

this is how i created the users table
yes it is 20 CHAR
do you mean that it have to be more then 20 cuz the md5 function going to make the {test} password more then 20 char's that why he always tellin me this user dose not exist cuz he is only read 20 ???