Record in Orders table keeps getting overwritten
I have a page with one static item. When I add it to the cart and successfully check out the Orders and Orderdetails tables get populated correctly. If I go through the whole process again, the data in the Orders and Orderdetails tables get overwritten by the new checkout. The ID of the Orders table is set to auto increment but for some reason it is not.