Checking passwords

[Micah Yoder <LYoder@cyberis.net>]

Is there any sample code to check the password from a MySQL account?

select * from Users where passwd=PASSWORD('my-password')

executes but returns nothing!

Working on the login script,
Micah