MySQL/Filemaker Experts: How would you do this?

[anonymouse1]

I want to run a web-enabled survey, where each respondent's answers are sliced and diced, a report generated, and the report emailed to that specific respondent.

The access to the survey would be password protected (specific password for each respondent), and I assume that there would be some kind of script/PHP on the website server that would query the database for passwords.

I realize this is pretty general; if you can point me towards any examples, or any good books, I'd really appreciate it.

Thanks!

[MacMagus]

Top result in a Google search:
http://www.devx.com/webdev/Article/27175

[Buzz]

not sure about where to find the resources you're looking for, but the basics of what you want to do are not that challenging. I've found the tougher aspect to be in the formatting of the report that is generated, unless your slicing and dicing is minimal and the report fairly benign. depending on the look and feel of the report, it may be easier to generate a picture or pdf based on a layout formatted for the desired report, and either embed or attach it to the email, rather than mess with formatting the report as part of the body of the email. good luck.

[anonymouse1]

Thanks, folks. Buzz, I'm talking about an attachment to an email. PDF is a good idea....

My googling led me to Jonathan Stark, as a good guy on Filemaker and PHP. Anybody know anything about him?