DELETE n1 FROM table n1, table n2 WHERE n1.id > 10000 AND n1.id < 11000 AND n1.id > n2.id AND n1.EMAIL = n2.EMAIL;

The above MySQL query will delete duplicate email addresses between the id’s 10000 and 11000. Breaking the query into blocks of 1000 id’s will reduce strain the MySQL server.

select EMAIL, count(EMAIL) as cnt
from TABLE
group by EMAIL
having cnt > 1 ORDER BY `cnt` DESC

The above MySQL query will find and list the number of multiple duplicate emails in a table.

• http://eclecticdjs.com/mike/tutorials/php/imagemagick/
• http://jamesroberts.name/blog/tag/imagick/
• Mikko’s blog

imagick is a more advanced graphics library than the default GD for PHP, but the ImageMagick PHP library imagick is only documented on PHP.net comments, so using the library can be a bit challenging, but the sites above help in using the library.


// Enter multiple query string
$query_str = "
-- Update table
UPDATE t SET id = id + 1;
-- Insert into table
INSERT INTO example (name, age) VALUES('John Doe', '23' );
";
// Explode string into separate queries
$query = explode(';',$query_str);
// Loop through exploded queries and execute
foreach($query as $index => $sql) {
$result = mysql_query($sql,$conn2) or userDisplayMessage(mysql_error().' '.__FILE__.':'.__LINE__);
}

Or, you can use mysqli (MySQL Improved extension), which has a mysqli_multi_query function.

IE6 only supports :hover on <a> elements. To change the cursor to a pointer or hand on hover of any non-anchor element, say a div:
In css

div {
cursor:hand;
cursor:pointer;
}
Do not add the pseudo state ‘:hover’, and it will work cross browser.