INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
last_login, UserID) VALUES ("Alf", "Stockton", "alf",
"0xd8cc7e40d17aaefd27cd324f7ba91079", 9, "2006/09/29 12:05:23", 0)
Put the hashed password in as a string.
Tom
-----Original Message-----
From: Alf Stockton [mailto:alf@xxxxxxxxxxxxxx]
Sent: 29 September 2006 11:46
To: php-windows
Subject: insert md5 password
Using MSSQL database I am attempting to insert a new user into a table
using the following command in PHP:-
INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel,
last_login, UserID) VALUES ('Alf', 'Stockton', 'alf',
0xd8cc7e40d17aaefd27cd324f7ba91079, '9', '2006/09/29 12:05:23', '0')
However this fails and I am not sure why.
BTW The value starting 0vd8....... is the password converted via md5()
Please tell me what I got wrong.
--
Regards,
Alf Stockton www.stockton.co.za
You have an unusual equipment for success. Be sure to use it properly.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
