X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_cats.php;h=d581889e30ae86fc90d9074554ae33f24ac240f3;hb=7618bd22d09e9bddab2ca39308f6523c06dd1521;hp=23cdb66c6b232c3c165c4527ac0854d48c8e9147;hpb=09f5758c42a33a56bdd461c946ffe759a59c54aa;p=mailer.git diff --git a/inc/modules/admin/what-list_cats.php b/inc/modules/admin/what-list_cats.php index 23cdb66c6b..d581889e30 100644 --- a/inc/modules/admin/what-list_cats.php +++ b/inc/modules/admin/what-list_cats.php @@ -55,7 +55,6 @@ if (isGetRequestParameterSet('userid')) { // Prepare constants // @TODO No longer needed? define('__CATS_BASE' , '' . $content['surname'] . ' ' . $content['family'] . ''; // Ok, list categories of this user @@ -64,14 +63,18 @@ if (isGetRequestParameterSet('userid')) { if (SQL_NUMROWS($result_cats) > 0) { // List categories $cnt = 1; $OUT = ''; $SW = 2; - while ($content = merge_array($content, SQL_FETCHARRAY($result_cats))) { + while ($row = SQL_FETCHARRAY($result_cats)) { + // Merge both arrays + $content = merge_array($content, $row); + // Check user's selection + // @TODO Rewrite this to countSum.....() function $result_user = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid`=%s AND `cat_id`=%s LIMIT 1", array(bigintval(getRequestParameter('userid')), bigintval($content['id'])), __FILE__, __LINE__); // Set selection - $selection = "{--NO--}"; - if (SQL_NUMROWS($result_user) == 1) $selection = "{--YES--}"; + $selection = '{--NO--}'; + if (SQL_NUMROWS($result_user) == 1) $selection = '{--YES--}'; // Add more elements $content['sw'] = $SW; @@ -84,7 +87,7 @@ if (isGetRequestParameterSet('userid')) { } // END - while // Free memory - SQL_FREERESULT($result); + SQL_FREERESULT($result_cats); // Remember all rows in the array $content['rows'] = $OUT;