Valid query

[chancho]

Is this a valid query with the PASSWORD function:

$check_query = "SELECT * FROM ismembercmp WHERE member_name = '$cl_name' AND PASSWORD( pswrd = '$cl_pswrd' )";

[Anon]

I think you mean:

paswrd = PASSWORD('$cl_pswrd')";

Diego

[chancho]

when I try: pswrd = PASSWORD( '$cl_pswrd' ); I don't get a match from the info that I submit with what resides in this db field. Can you suggest any solution?

[Anon]

What is pswrd? is it encrypted using PASSWORD()? or just plain text?

Diego

[chancho]

It is encrypted with PASSWORD().