You need to use PASSWORD() function..
INSERT INTO table VALUES('0', 'username', PASSWORD('passwd'), 'email');
See: http://mysql.com/doc/M/i/Miscellaneous_functions.html
Gurhan
-----Original Message-----
From: Jule [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 8:37 PM
To: [EMAIL PROTECTED]
Subject: password function
Hey guys and gals,
How do i add info to a table, and give a varchar(16) row the function of
password, so that it is encrypted? my query now is:
INSERT into table values('0', 'username', 'password', 'email')
thanks
Jule
--
|\/\__________________________/\/|
| Jule Slootbeek |
| [EMAIL PROTECTED] |
| http://blindtheory.cjb.net |
| __________________________ |
|/\/ \/\|
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
