I run a site that sells subscriptions to a magazine. I have a simple script that collects user data, enters it into a mySQL db and emails me a confirmation. This script has been working fine for over a year now. I recently updated the script to use sessions to store the data across acesses (after initial input, there is a confirmation page where users can see what they entered and make changes before doing a final submit to the db). Since I started with sessions, I have been getting occassional blank database entries; records that are totally blank except for the primary key field (which is auto incremented). I don't understand how this is possible. I have pretty comprehensive form validation going on (via PHP and JavaScript) that make it impossible to submit a blank form. These blanks seem to happen in pairs or sometimes 3 at a time and they all happen in quick succession (within 30 to 60 seconds apart).
It seems as if maybe the session variables are getting lost right before the database entry. Again this problem is intermittant, most of the time the script works fine and I cannot duplicate this problem on my local dev machine. Any ideas? thanx
