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