mysql password function

[admin]

I'm getting an error everytime i try to select a password from a database using the password() function. heres what i have

$query = "SELECT * FROM user WHERE password = password('$pwd')";

since the passwords are stored using the password function, how can i retrieve them for authentication?

thanks - null