Piping email is the way to go. I do it with my blog/journal/whatever. If you're using Cpanel, you can setup a forwarding email address (it doesn't need its own email box) and "pipe" it to your PHP script. The entry for the forwarding address in Cpanel would look like: "|[full path to PHP script]" - you'll need to include the quotes. Then you need to chmod your script to 777 and then work backwards until it fails (it'll need read and execute at the least). Then you'll need to add this to the first line of your PHP script: #!/[path to PHP parser]/php (this tells the shell what to do with the file)
Then in your PHP script, you'll need to read the stdIn like a file. Once you read it all in, you can then parse it and do whatever you like (including posting it to a web page or database). I discovered not long ago the Pear Mail_mimeDecode object. I HIGHLY recommend this as it'll allow you to send attachments to your script and have it parse them if you want it to (like pictures and such).