Form results insert to mysql

[BevO]

Hello - Russell
I have the form setup and running really well. What a great application, thank you!
I have added a php script to the final page of my multi-page form to insert the form data into a mysql database and a PayPal buy now button. The script to PayPal works fine - but, I have not been successful inserting the form data into a mysql database. Is there anything I should know about the interaction between FormMail and a simple database insert script?
I don't receive any errors when I load the final page - the PayPal button works just fine, but, I also don't get any entries to the database.
Thank you,
BevO

[russellr]

Hi,

Here's what I would do in this situation:

1. Create a new PHP script.
2. Add the code that writes something to the database each time the script is run.
3. Run the script from my browser.
4. Check that the database was written to.
5. If not, debug this script until it works.
6. Run the script many times to confirm that it writes to the DB each time I open it in my browser.
7. Copy the script to the Thank You page script.
8. Re-test using the Thank You page directly (if possible).
9. Re-test using the complete form process.

It's the old "Divide and Conquer" concept. Us programmers do this most the time - and when we don't do it (because we can't be bothered), the problem usually takes 5 times longer to solve.

It seems like a bit of effort to go to, but it really is the best way to diagnose this type of problem.