Falko, with that query, MySQL will use a different salt every time you call it, so the same entered password, it will be saved differently in the db, and you can never match against it, since you don't know the salt mysql used during
INSERT INTO users(name, pass) VALUES('john', ENCRYPT('password','(*#Ng383'));
This will save the same encrypted string over and over.
for his solution he should use:
("odufmsircklsc" being the salt)
INSERT INTO users(..., password) VALUES('...', ENCRYPT(".$_POST['password'].", 'odufmsircklsc'));