$query = "select * from mytable where user_name ='$user_name' and pass_word = password('$pass_word')";
this code gives me problems. when i enter a password into my table using phpmyadmin and i DON'T use the 'password' function and i DON'T use the password function in my sql query, then everything works fine. if, however, i use the 'password' function in my sql statement above and i enter passwords in phpmyadmin using the 'password' encryption, nothing works.
this code gives me problems. when i enter a password into my table using phpmyadmin and i DON'T use the 'password' function and i DON'T use the password function in my sql query, then everything works fine. if, however, i use the 'password' function in my sql statement above and i enter passwords in phpmyadmin using the 'password' encryption, nothing works.