ENCODE(value, 'secret code') DECODE(field name, 'secret code') to record " ... VALUES ( ... blahblah, ENCODE('$passord', 'secret code', ... BLAH BHAL") ;
and to read the value do like this MYSQL_QUERY("SELECT DECODE(password, 'secret code') as password, id, BLAH BLAH ----- Original Message ----- From: "Ben C." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 13, 2002 12:07 PM Subject: Re: [PHP] Trying to e-mail password > Is there not any way to reverse the crypted password before e-mailing?? > > If not, how do I use ENCODE / DECODE? > > > > > > From: "rija" <[EMAIL PROTECTED]> > > Date: 2002/11/12 Tue PM 07:32:28 EST > > To: "php" <[EMAIL PROTECTED]>, > > "Ben C." <[EMAIL PROTECTED]> > > Subject: Re: [PHP] Trying to e-mail password > > > > You should do like this: > > > > $password = $row['password']; > > This return weird crypted value of your password. > > > > Unless you want send the this weird password. The function mysql_password is > > irreversible, you cannot get back the value crypted by password. Use ENCODE > > and DECODE instead, > > > > > > > > ----- Original Message ----- > > From: "Ben C." <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, November 13, 2002 11:09 AM > > Subject: [PHP] Trying to e-mail password > > > > > > > I am trying to have a form that send a user their email and password to > > login. I am using the following: > > > > > > while ($row = mysql_fetch_array($result)) { > > > $email = $row['email']; > > > $password = $row['password(password)']; > > > > > > When I use the mail() function to send both $email and $password I receive > > an e-mail with a blank password. > > > > > > What am I doing wrong. Please help! > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php