I needed to delete duplicate entries in MySql with PHP. After some trial and error I wrote a script that will do it for me. What I needed to do was delete duplicate email addresses in a email script. Here is the code that made that magic happen.
[code] $result = $con->query("SELECT email FROM newsusers group by email having count(*) >= 2") ;
while ($row = $result->fetch_assoc()) {
$orgemail=$row[’email’];
echo $orgemail;
echo ‘<br/>’;
mysqli_query($con,"DELETE FROM newsusers WHERE email=’$orgemail’ ");
}[/code]
Delete Duplicate Entries In MySql with PHP was last modified: August 5th, 2016 by
A1WEBSITEPRO Social Media Pages
Here are my social media pages, lets hook up!