[thelist] don't know what this SQL does...

Aaron Holmes aholmes at pureguru.com
Sat Aug 30 15:18:09 CDT 2003

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

You can also use other functions in this manner ( ie. Now() and md5()

Sincerely yours, 
Aaron Holmes
Gurix Web Professionals
Welland, Ontario
Corporate e-mail: aholmes at gurix.com
V: 905.324.3241
F: 905.734.1398
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?



PS: This came from PH script I'm fiddeling with.

* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list