insert email content to db



hi guys,

can u guys give me an idea how actually we can insert something into the database based on the email we received ??

it is something like what this website can do..

when i add a new ticket, i will receive an email (i know how this can be done).. when the time they reply me. their reply will be inserted into database and i will get an email too ( i know how to get this done too).. when i replied by using email, whatever i replied will be inserted into their database directly.. how could that be done ?? did they do that by using php ?? since email doesn't go through any file, why whatever i replied will be stored in their database,, this sounds cool to me.

do u guys mind to give me an idea how to create this kind of system ??

Well, to do this you're going beyond PHP. The simplest way to do this would be to make your PHP script check the POP box and download any new e-mails and add them to the database, and then schedule a cron job to run the script every X minutes. The disadvantage of this is that it's not quite realtime. There would be a delay of at most X minutes before new e-mails were added to the database.

There are other ways to do this, but they all involve implementing custom email-handling software on the e-mail server, and that's beyond my expertise.