X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-mydata.php;h=83392c1cb0bf2c145ae91f7c12dec9c3c85a5283;hb=8202991f32bfb2056e94a11746c0b5308fe4a273;hp=0f21b5b461313087cca56fbfe1e161b8adc17230;hpb=0a37fc5afcd828646d4e62e68fea07c3d2c54a87;p=mailer.git

diff --git a/inc/modules/member/what-mydata.php b/inc/modules/member/what-mydata.php
index 0f21b5b461..83392c1cb0 100644
--- a/inc/modules/member/what-mydata.php
+++ b/inc/modules/member/what-mydata.php
@@ -210,7 +210,7 @@ LIMIT 1",
 
 				// Did the user changed the password?
 				if ($hash != $content['password']) {
-					$AND = ", `password`='" . $hash . "'";
+					$AND = ",`password`='" . $hash . "'";
 					$mode = 'password';
 				} // END - if
 
@@ -231,11 +231,11 @@ LIMIT 1",
 					SQL_QUERY_ESC("UPDATE
 	`{?_MYSQL_PREFIX?}_user_data`
 SET
-	`gender`='%s', `surname`='%s', `family`='%s',
+	`gender`='%s',`surname`='%s',`family`='%s',
 	`street_nr`='%s',
-	`country_code`=%s, `zip`=%s, `city`='%s',
+	`country_code`=%s,`zip`=%s,`city`='%s',
 	`email`='%s',
-	`birth_day`=%s, `birth_month`=%s, `birth_year`=%s,
+	`birth_day`=%s,`birth_month`=%s,`birth_year`=%s,
 	`max_mails`='%s',
 	`last_update`=UNIX_TIMESTAMP()".$AND.",
 	`notified`='N',
@@ -263,11 +263,11 @@ LIMIT 1",
 					SQL_QUERY_ESC("UPDATE
 	`{?_MYSQL_PREFIX?}_user_data`
 SET
-	`gender`='%s', `surname`='%s', `family`='%s',
+	`gender`='%s',`surname`='%s',`family`='%s',
 	`street_nr`='%s',
-	`country`='%s', `zip`=%s, `city`='%s',
+	`country`='%s',`zip`=%s,`city`='%s',
 	`email`='%s',
-	`birth_day`=%s, `birth_month`=%s, `birth_year`=%s,
+	`birth_day`=%s,`birth_month`=%s,`birth_year`=%s,
 	`max_mails`='%s',
 	`last_update`=UNIX_TIMESTAMP()".$AND.",
 	`notified`='N',
@@ -311,7 +311,7 @@ LIMIT 1",
 		break;
 
 	case 'notify': // Switch off notfication
-		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `notified`='N', `last_update`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
+		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `notified`='N',`last_update`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
 			array(getMemberId()), __FILE__, __LINE__);
 		$url = 'modules.php?module=login&what=mydata&code=' . getCode('PROFILE_UPDATED');
 		break;