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
How is a session id generated?
The left association operator % is used in PHP for?
How many types of array supported in php?
How we get browser details of clients machine?
What is csrf verification?
Is age interval or ordinal data?
Where are cookies stored php?
What is php built on?
Why sessions are used in php?
How do you end a function in python?
Explain me what is the use of header() function in php?
How would you open a directory for reading in php?
What is the use of mvc in php?
Does php 7 support multiple inheritance?
What are the differences between php3 and php4 and php5? What is the current stable version of php? What advance thing in php7?