Parsing email body into MySQL Databse

[Anon]

Hi, I really could use some coding help on the following problem. Note: I am new to PHP, MySQL and Linux in general.

Server: Red Hat 7.0
Sendmail
PHP4
MySQL
The email messages I am trying to parse out are created via a 3rd party form. The emails are then sent to my mailbox in text format. The format of the message body is simular to that below:

Name: Joe Thompson
Street: 123 Wishing Way
email: [e-mail]

What I am trying to accomplish is to parse each colon delimited entry into a MySQL database table i.e.:
FirstName
LastName
Address
email

Can someone please explain how to code this or if there is a pre-made program that would parse my email body into a database using the colon as the delimiter?

Thank you,
Michael

[Anon]

where will the incoming data be stored? each entry in a separate file or one big file with all of the entries?

[Anon]

Each parsed string needs to be inserted into a table field in a MySQL database.

[Anon]

yes, but what about the incoming data? where will it be? in a separate file or files, in an array???

[Anon]

As I stated, I am new to all this, so thanks for your patience.

The mail messages are sent into a mailbox in Sendmail.

I need to process each email message as it arrives to the server mailbox, inserting the text strings into the table.