Rewrote handling of extra SQL columns/data for registration. The very generic filter...

[mailer.git] / inc / filter / order_filter.php

diff --git a/inc/filter/order_filter.php b/inc/filter/order_filter.php
index 4abbd40c7c6972dfd70bf8ba93677f5bbcf5ec39..3fd044f61466cf061e60cec7d01bdbee8240a820 100644 (file)
--- a/inc/filter/order_filter.php
+++ b/inc/filter/order_filter.php
@@ -85,11 +85,11 @@ function FILTER_ORDER_ZIP_CODE_SQL ($sql) {
        if ((isOrderMultiPageEnabled()) && (isPostRequestElementSet('zip')) && (postRequestElement('zip') != '')) {
                // Choose recipients by ZIP code
                if (empty($sql)) {
-                       $sql = sprintf(" WHERE d.`zip` LIKE '%s%%'",
+                       $sql = sprintf(" WHERE `zip` LIKE '%s%%%%'",
                                bigintval(postRequestElement('zip'))
                        );
                } else {
-                       $sql .= sprintf(" AND d.`zip` LIKE '%s%%'",
+                       $sql .= sprintf(" AND `zip` LIKE '%s%%%%'",
                                bigintval(postRequestElement('zip'))
                        );
                }