updating a database from a received email

    Date: 04/01/09 (MySQL Communtiy)    Keywords: php

    hey everyone,
    i've got a problem and having a hard time wrapping my head around a solution.

    i'm writing an app in php that will send an email notification to about 100 people, my boss wants to know how many people actually open the emails, so what i've done is created a field in the db for views.

    what i want to do is when someone opens the email it increments the views by 1. simple enough right?
    i thought maybe i'd hide an iframe in the email that goes to a php script on the server that would update the views in the db. hit a road block since 99% of email clients now block or disable iframes in emails.


    so are there any other ways to go about doing this?

    Source: http://mysql.livejournal.com/134169.html

« Efficient full-text searchs... || Find datetimes with time of... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home