]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/member/what-categories.php
Mailer project continued:
[mailer.git] / inc / modules / member / what-categories.php
index d3fb3b9d62d6fffe5997a4549f67819d29f96f01..7c6b40505570689ca1fd7bff348ae72131d4c99e 100644 (file)
@@ -49,7 +49,7 @@ $whereStatement = " WHERE `visible`='Y'";
 if (isAdmin()) $whereStatement = '';
 
 // Get all categories
-$result = SQL_QUERY("SELECT `id`,`cat` FROM `{?_MYSQL_PREFIX?}_cats`".$whereStatement." ORDER BY `sort` ASC", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT `id`, `cat` FROM `{?_MYSQL_PREFIX?}_cats`".$whereStatement." ORDER BY `sort` ASC", __FILE__, __LINE__);
 
 // Are there entries?
 if (!SQL_HASZERONUMS($result)) {
@@ -82,7 +82,7 @@ if (!SQL_HASZERONUMS($result)) {
                                        // Check if this category has an entry
                                        if (countSumTotalData(getMemberId(), 'user_cats', 'id', 'userid', true, sprintf(" AND `cat_id`=%s", bigintval($categoryId))) == 0) {
                                                // No, so add it
-                                               addSql(sprintf("INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (`userid`,`cat_id`) VALUES (%s,%s)", getMemberId(), bigintval($categoryId)));
+                                               addSql(sprintf("INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (`userid`, `cat_id`) VALUES (%s,%s)", getMemberId(), bigintval($categoryId)));
                                        } // END - if
                                        break;