TalkPHP - View Single Post

sketchMedia · 02-15-2008, 12:32 PM

Looks to me like your SQL is a bit squiffy.

PHP Code:


			
$query = ' 
INSERT INTO users SET 
    user_name = "'.($reg_username).'" 
    , email = "'.($reg_email).'" 
    , user_pass = "md5($reg_password).'" 
    , user_pass_conf = "'.($reg_pass_conf).'" 
';

should be more like

PHP Code:


			
$query = 'INSERT INTO users SET
    user_name = "'.$reg_username.'",
    email = "'.$reg_email.'",
    user_pass = "md5('.$reg_password.')",
    user_pass_conf = "'.$reg_pass_conf.'"';

anyway my advice for hasing values would be to use the PHP hash() function

02-15-2008, 12:32 PM	#28 (permalink)
sketchMedia The Prestige Join Date: Oct 2007 Location: Manchester, UK Posts: 854 Thanks: 32	Looks to me like your SQL is a bit squiffy. PHP Code: `$query = ' INSERT INTO users SET user_name = "'.($reg_username).'" , email = "'.($reg_email).'" , user_pass = "md5($reg_password).'" , user_pass_conf = "'.($reg_pass_conf).'" ';` should be more like PHP Code: `$query = 'INSERT INTO users SET user_name = "'.$reg_username.'", email = "'.$reg_email.'", user_pass = "md5('.$reg_password.')", user_pass_conf = "'.$reg_pass_conf.'"';` anyway my advice for hasing values would be to use the PHP hash() function __________________ mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0; Empty set (0.00 sec)