[Resolved] website navigation corrupting data

[Gladiator2043]

I am developing a website that gets misc information from customers step by step.

e.g on page one it gets the personal information
on page 2 it would start building an order
on page 3 it would have credit card info etc.

Now if the customer follows the website navigation, everything is fine. But my data seems to get corrupted in database when they start going back from the browser.

for example if a customer just added there order and goes to the next page for the credit card info page, and if they go back to the previous page using th ebrowser back button.

any suggestions?

[melody]

After having a quick think about this, here's what I'd do...

Assign each customer a unique order number when they start filling in the forms. This can be passed to each of the pages by session variable. The information in your database can be identified by this unique number. Then, if a user goes back, query the database with the unique number. If results are returned, it means the customer has already entered the info once and wants to change it - you need to UPDATE information to the database and not INSERT. Else if there is no data stored in the database, INSERT the information instead.

HTH
Melody

[Gladiator2043]

awesome..thankyou.