natasha
-
Posts
3 -
Joined
-
Last visited
Never
Posts posted by natasha
-
-
hi
Hmm.. this may sound silly to u..but I am pretty new to mysql. I hv just used the function password(string) to encrypt the password field in the database. and I just using \'password=password(\'$txtpassword\') as part of my query. It just refuses to authenticate..very maddening!
natasha
-
hi all,
I am using PHP-MySql and use the following code for login authentication:
<?
$res=@mysql_query(\"select * from users where login=(\'$txtlogin\') and password=password(\'$txtpassword\')\");
?>
$txtlogin and $password are the text field names. The database has stored the password in the encrypted format. But still it i snot authenticating.
The connection to mysql etc is working. Without the encryption, the logn authentication works...what can be possibly wrong?
a very very perplexed
Natasha. :?:
Password function error in Mysql
in MySQL Help
Posted
yeah that is what I hv been doing the entire day today..will give it a shot tomorrow again!!
Thanks a lot.