Re: insert md5 password

Bruce Cowin wrote: > Strange. Do you know it's the password causing the problem? What if you pass an empty > string for the password and see if the insert works? > > Good suggestion Bruce, thank you. Did the blank password and still get the same error therefore possibly I am misunderstanding the PHP Manual, where it says:- mixed *mssql_query* ( string query [, resource link_identifier [, int batch_size]] ) Returns: A MS SQL result resource on success, *TRUE* if no rows were returned, or *FALSE* on error. and my code reads:- $passwd = ""; // for debugging only $insert = sprintf("INSERT INTO Users (FirstName, LastName, Usrname, Passwrd, AccessLevel, last_login, UserID) VALUES ('%s', '%s', '%s', '%s', '%d', '%s', '%d')", $FirstName, $Surname, $uname, $passwd, $accesslevel, $regdate, $_SESSION['UID']); $Reply = mssql_query($insert, $link); if ($Reply == FALSE) { $Message = sprintf("%s %d <br>Record not inserted. Please refer problem to Admin.", __FILE__, __LINE__); trigger_error($Message, E_USER_ERROR, $link); exit; } Maybe on an insert, no rows would be returned and therefore I possibly should be checking for something else? -- Regards, Alf Stockton www.stockton.co.za Q: Why is it that Mexico isn't sending anyone to the '84 summer games? A: Anyone in Mexico who can run, swim or jump is already in LA. My email disclaimer is available at www.stockton.co.za/disclaimer.html