Form that writes to a CMS table

Hi Zip222,

I'm also a proponent of using CAPTCHA in my forms instead of "hidden" fields. I find that actively filling in a CAPTCHA code field gives the person filling out the form the feeling that their information is somehow safer.

I originally used the Google app, but switched to using a program called CAPTCHA creator. I find it much easier to customize then the Google app.

Just in case you want to do some other things with your form, I've attached a fairly comprehensive set of php files that I've used for signing up members for a client of mine's website. (I changed paths and web addresses to generic ones for the samples)

There's error checking, automatic posting to hidden fields, automatic display of existing data, and more, including how to work with date fields in your form.

As you discovered, you'll have to have a field in your table you're using for each field referenced in the form.

There are a there are a number of recipes dealing with form customization in my CMSB Cookbook http://www.thecmsbcookbook.com

Hope the attachment helps to clear up some of the finer points.

Jerry Kornbluth