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 an array in php?
How to generate a form?
What are the rules to declare a php variables?
What is the difference between null and empty?
Explain the importance of the function htmlentities.
What is a php 5?
What is the difference between htmlentities and htmlspecialchars in php?
Explain what is the difference between $var and $$var?
Is php fully object oriented?
What is psr in php?
How to delete an element from an array?
How to download and install php on windows?
How does php work?
Explain what does $_files means?
How does php sessions work?