RE: [PHP-WIN] insert md5 password

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@stockton.co.za] Sent: 29 September 2006 11:46 To: php-windows Subject: [PHP-WIN] 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