X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_user.php;h=2f399f092352c9ca6261561c88d9111d4c47bd39;hb=7800e16349a7f1ccd0eccc3197c81fc261740937;hp=410ac203a535a574f45b449eac9031f082e3e763;hpb=357b2ca133fc1f89db74097955c366cb4bee6996;p=mailer.git diff --git a/inc/modules/admin/what-edit_user.php b/inc/modules/admin/what-edit_user.php index 410ac203a5..2f399f0923 100644 --- a/inc/modules/admin/what-edit_user.php +++ b/inc/modules/admin/what-edit_user.php @@ -44,8 +44,11 @@ ADD_DESCR("admin", __FILE__); $result_main = false; if (isset($_GET['u_id'])) { // 0 1 2 3 4 5 6 7 8 9 10 11 - $result_main = SQL_QUERY_ESC("SELECT gender, surname, family, street_nr, zip, city, country, email, birth_day, birth_month, birth_year, max_mails FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); + $result_main = SQL_QUERY_ESC("SELECT gender, surname, family, street_nr, zip, city, country, email, birth_day, birth_month, birth_year, max_mails +FROM `"._MYSQL_PREFIX."_user_data` +WHERE userid=%s +LIMIT 1", + array(bigintval($_GET['u_id'])), __FILE__, __LINE__); } if ((SQL_NUMROWS($result_main) == 1) || (empty($_GET['u_id']))) @@ -74,7 +77,7 @@ if ((SQL_NUMROWS($result_main) == 1) || (empty($_GET['u_id']))) if ($PASS) { // We have to add the following things: birthday and max receive mails - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET + SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET gender='%s', surname='%s', family='%s',