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 is csrf verification?
Which is the best web server?
What is session in c#?
What is "echo" in php?
What are form input html tags?
In PHP, fgets() is used to read a file one line at a time. State Whether True or False?
Describe PHP error and logging information?
What is the purpose of the '.frm' file extension? What do thes file contain?
Where are the persistent cookies stored on your computer?
How do you check if a variable has not been set in php?
What is a path Traversal?
Is uploaded file php?
What is a http session?
What is php trait?
What enctype is required for file uploads to work?