Thanks moskito,
but it did not work, th eporblem I have is that encrypt retunrs each time an encrypted string differetne form the previous so the passwords do not match.
for instance:
SELECT encrypt('abc') as string FROM `users` LIMIT 1
Z9Uu2KHZiz/6Y
SELECT encrypt('abc') as string FROM `users` LIMIT 1
HAgC9F0JjlOCE
The passwords never match..
regards,
|