What does Muller Digital do?
Besides offering web-programming services and advice, one of the primary objectives of Muller Digital is to share technical information. We have set up this “bulletin board” to do just that. New information will be updated on a regular basis.

MySQL remove duplicates

December 9th, 2011

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.

MySQL find duplicates

December 9th, 2011

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.

Search web by image

November 28th, 2011

http://www.tineye.com/ allows you to search the web for similar images to ones uploaded or on the web.

UPDATE: Google has this as well: http://www.google.com/insidesearch/searchbyimage.html

Generate / Create QRcode 2D barcodes ( primarily QRcodes ) in raster and vector formats

October 19th, 2011
  • www.qrstuff.com ? You can generate QR Codes (the most popular 2D barcode) for Website URL, YouTube Video, Google Maps Location, Social Media, iTunes Link, Plain Text, Telephone Number, SMS Message, Email Address, Email Message, Contact Details (VCARD), Event (VCALENDAR), Wifi Login (Android Only), Paypal Buy Now Link. With QRstuff.com you to change colour of the positive QR Code shapes (the dark part).
  • qrcode.littleidiot.be ? You can generate QR Codes for Regular text, Hyperlink, Phone number, Email address, meCard, vCard, WiFi settings. There is also the option to download the QR Code in multiple formats, particularly vector based formats. QR Stuff only does raster (bitmap) formats.

PHP imagick – website references, manuals and information

September 7th, 2011

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.