[PHP] MySQL Functions in WHERE clause (OT) From: Ben Wiechman (neteru <email protected>)
Date: 12/29/00

Anyone have an idea why the following won't work for me...

I have a table with two fields, login & password.

Using the following line to insert values into this table.
"INSERT INTO auth (login, password) VALUES ('user', PASSWORD('pass'))"

Now, when I try to select by password from the table using the following, I
get nothing. It doesn't find the correct row.
"SELECT * FROM auth WHERE password = PASSWORD( 'pass' )"

Can anyone see anythign wrong with this? I'm stumped.

Ben 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>