Best method of identifying users from the db?

[Adrian Schneider]

Check their username/password against the vB. database.

select userid
from user
where username = 'usetname sent' and password = md5(concat(md5('password sent'), salt));