query($query); while (($row = $db->fetchByAssoc($result)) != null) { if(!isset($rows[$row['id']])) { $rows[]=$row; } } $count = 0; $emails = array(); $emailStr = ''; while(isset($_POST['emailAddress' . $count])) { $emailStr .= ",'" . strtoupper(trim($_POST['emailAddress' . $count++])) . "'"; } //while if($count > 0) { $emailStr = substr($emailStr, 1); $query = 'SELECT DISTINCT er.bean_id AS id FROM email_addr_bean_rel er, ' . 'email_addresses ea WHERE ea.id = er.email_address_id ' . 'AND ea.deleted = 0 AND er.deleted = 0 AND er.bean_module = \'Contacts\' ' . 'AND email_address_caps IN (' . $emailStr . ')'; $result = $db->query($query); while (($row= $db->fetchByAssoc($result)) != null) { if(!isset($rows[$row['id']])) { $query2 = "SELECT id, first_name, last_name, title FROM contacts WHERE deleted = 0 AND id = '" . $row['id'] . "'"; $result2 = $db->query($query2); $r = $db->fetchByAssoc($result2); if(isset($r['id']) && !array_key_exists('id', $r)) { $rows[]=$r; } } //if } } //if return !empty($rows) ? $rows : null; } function buildTableForm($rows, $mod=''){ global $action; if(!empty($mod)){ global $current_language; $mod_strings = return_module_language($current_language, $mod); }else global $mod_strings; global $app_strings; $cols = sizeof($rows[0]) * 2 + 1; if ($action != 'ShowDuplicates') { $form = '
'.$mod_strings['MSG_DUPLICATE']. ' |