Advanced Form Processor to mySQL

Issues related to forms.
Post Reply
thisazlife
 
 
Posts: 72
Joined: Mon Apr 24, 2017 4:19 am
Location: Chandler, AZ USA
Contact:

Advanced Form Processor to mySQL

Post by thisazlife »

I've not done this feature before and am having an issue that I can't figure out. I'm hoping someone here can couch me.
I created a mySQL database on my host. I then created a form using WYSIWYG Web Builder and used the Advanced Form Processor Properties to connect the form to the database.

I can enter data into my new form and submit, the data shows up as an entry in my database. Next I repeat with different data in the form and submit. I expect to find two different entries but instead I find 3 entries all the same data from the last data that wrote to the database. I'm certainly not an expert at mySQL so I'll take any suggestions I can get. Thanks so much!
Steve Colbeth
Arizona Real Estate Agent / Consultant
http://stevecolbeth.com
me@stevecolbeth.com
Chandler, Arizona - USA
User avatar
Pablo
 
Posts: 21582
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Advanced Form Processor to mySQL

Post by Pablo »

This is not normal behavior, but may there is an issue with your browser cache?
thisazlife
 
 
Posts: 72
Joined: Mon Apr 24, 2017 4:19 am
Location: Chandler, AZ USA
Contact:

Re: Advanced Form Processor to mySQL

Post by thisazlife »

Thanks Pablo!
I thought I had deleted this topic because I figured it out. In the mySQL database I had to set one of the records as an incremental record. I labeled it "ID". Now each record gets a different unique ID and the records increment as they are added.

Thanks for your quick response!!
Steve
Steve Colbeth
Arizona Real Estate Agent / Consultant
http://stevecolbeth.com
me@stevecolbeth.com
Chandler, Arizona - USA
Post Reply