Hi Walter, Which database are you using? In MySQL for instance, the password() function is used on queries to insert a password hash. I won't go into detail, but look at http://www.mysql.com/doc/en/Password_hashing.html if you want to know more. You can also use other functions in this manner ( ie. Now() and md5() etc.) HTH! Sincerely yours, Aaron Holmes CEO Gurix Web Professionals Welland, Ontario Canada Corporate e-mail: aholmes at gurix.com V: 905.324.3241 F: 905.734.1398 http://www.gurix.com Subscribe to "Balancing Today's Technology," our free, monthly, electronic newsletter about using technology in business by e-mail to: join-todaystech at gurix.com -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of jsWalter Sent: Saturday, August 30, 2003 4:02 PM To: thelist at lists.evolt.org Subject: [thelist] don't know what this SQL does... UPDATE authuser SET passwd=password('$password') OK, will I sort of know waht it does. But I never saw that passwd=password('$password') command before Can someone explain it to me? thanks walter PS: This came from PH script I'm fiddeling with. -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !