I am trying to forward incoming emails to a php script that checks the subject and stores a record (Time Stamp, Sender) for that subject in the DB.
I am using webhostingpad as my server service with cpanel 11.
I know how to setup up the forwarding / piping to script. I have created an SQL table called 'emails' which contains only these columns: ID, Subject
Now I want the script to check the incoming email's subject with the list of subjects in the DB and then record an entry with the time stamp for the corresponding Subject column.
How do I write the script for this purpose ?