WampServer

This is problem,

This is query on my registration page

$result = mysql_query ("INSERT INTO users (name, password, email, showemail)
VALUES ('$user', PASSWORD('$pass'), '$email', '$showemail')";

And this is query on login page

$result = mysql_query("SELECT * FROM users WHERE name = '$user'
AND password = PASSWORD('$pass')";

When i register i try to login on that acc and query return 0 results, if i use just this query

$result = mysql_query("SELECT * FROM users WHERE name = '$user'";

it's working fine

Someone Anyone

Hi,

The MySQL Reference manual recommends the MD5() or SHA1() functions to be used in applications, not PASSWORD() which is used internally by the MySQL Server - see [dev.mysql.com].

You could also use the same functions in PHP, for example md5() or sha1(), rather than getting the MySQL Server do the encryption, see [php.net].

Regards,

toivo
Sydney, Australia

tnx