Re: sha1 function in MySql query.

[MARK LINDQUIST]

My code is all PHP meaning the queries are quoted strings. My insert statement inserts username and password into db. The results are echoed to the page. Likewise my SELECT statement selects username and password and echoes them for testing to the page.

If I use sha1 in either insert or select statements on the password field, the SELECT statement won't echo the results. The INSERT statement, even with sha, works fine.

$strLogin = "INSERT INTO t (username, password) VALUES ('$username', sha1('$password'))";

$query = "SELECT username, password FROM t WHERE username = '$user' AND password = sha1('$password')";