Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT * FROM {$dbPre}email GROUP BY leadID HAVING COUNT(*) > 1";
- $results = $db->extQuery($sql);
- /*Insert contacts in doublets*/
- $sql="INSERT INTO {$dbPre}doublets select * FROM {$dbPre}contacts WHERE NOT (id LIKE ";
- foreach ($results as $row => $result) {
- $sql=$sql.$result->leadID." OR id like ";
- }
- $sql=rtrim($sql, " OR id like ");
- $sql=$sql.");";
- echo $sql;
- $insert = $db->extQuery($sql);
- /*Delete contacts from table*/
- $sql="DELETE FROM {$dbPre}contacts WHERE NOT (id LIKE ";
- foreach ($results as $row => $result) {
- $sql=$sql.$result->leadID." OR id like ";
- }
- $sql=rtrim($sql, " OR id like ");
- $sql=$sql.");";
- $deletes = $db->extQuery($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement