Email parsing into MySQL with PHP

I need an application writing that will receive all incoming emails to a specified domain, parse them, modify some content on them and store them in a MySQL database. The mail server will be Sendmail and will be hosted on a Linux box that I have root access on. Sendmail will need to invoke this script every time an email is sent to a specific domain. I will take care of this part of the project in the live environment. The freelancer just needs to write the PHP application for me. I need the following data storing in the database: ID Sender email address Sender's company * Date Subject Content ** * The sender's company will be one of a number of companies in a lookup table. The script needs to detect the sender's company from either the sender's email address, text in the subject or text in the content. ** Most of the emails received will be HTML emails. If an email has HTML content then it is the HTML part that wants storing in the database, if there is no HTML then only the text part wants to be stored. Any HTML links need to be parsed to add an affiliate ID in them. I am also open to other suggestions on how to approach this and if someone can provide the same functionality reading the emails via either POP/IMAP then I will consider this too.