Advertisement
Guest User

Untitled

a guest
Oct 28th, 2014
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. $sql = "SELECT * FROM {$dbPre}email GROUP BY leadID HAVING COUNT(*) > 1";
  2.     $results = $db->extQuery($sql);
  3.     /*Insert contacts in doublets*/
  4.     $sql="INSERT INTO {$dbPre}doublets select * FROM {$dbPre}contacts WHERE NOT (id LIKE ";
  5.     foreach ($results as $row => $result) {
  6.         $sql=$sql.$result->leadID." OR id like ";
  7.     }
  8.     $sql=rtrim($sql, " OR id like ");
  9.     $sql=$sql.");";
  10.     echo $sql;
  11.     $insert = $db->extQuery($sql);
  12.    
  13.     /*Delete contacts from table*/
  14.     $sql="DELETE FROM {$dbPre}contacts WHERE NOT (id LIKE ";
  15.     foreach ($results as $row => $result) {
  16.         $sql=$sql.$result->leadID." OR id like ";
  17.     }
  18.     $sql=rtrim($sql, " OR id like ");
  19.     $sql=$sql.");";
  20.     $deletes = $db->extQuery($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement