Answer Posted / rakesh dongarwar
$query="SELECT * FROM `emails` ORDER BY `email` ASC LIMIT 0, 30";
mysql_query($query);
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
$totalemailsdeleted=0;
$i=1;
$i2=0;
while($i2 < $numrows)
{
$id=mysql_result($result, $i2, id);
$email=mysql_result($result, $i2, email);
while($i < $numrows)
{
$idcompare=mysql_result($result, $i, id);
$emailcompare=mysql_result($result, $i, email);
if($emailcompare == $email)
{
$query="DELETE FROM `emails` WHERE `id` = '$idcompare' LIMIT 1";
mysql_query($query);
$emailsdeleted.="$emailcompare<br>";
$totalemailsdeleted++;
$numrows=mysql_num_rows($result);
}
else
{
}
$i++;
}
$i2++;
}
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
What’s the difference between htmlentities() and htmlspecialchars()?
How to join multiple strings stored in an array into a single string?
How can we determine whether a variable is set?
Is php dead 2019?
Tell me what is pear?
How to create a session? How to remove data from a session?
Is wordpress a php framework?
Can you use both this () and super () in a constructor?
How check field is empty or not in php?
What is the Pipe Symbol represented?
Does mysql need php?
my english is not too good then what we apply for a php programer post
Write a program to show the joining of two strings in php?
Where to put php files in apache server?
How variables are passed through arguments?