Error on confirm page. "Unknown column 'IP9016' in 'field list'"

Error on confirm page. "Unknown column 'IP9016' in 'field list'"

When DW crashed. I reinstalled all my extensions and started over to build the shopping cart function. Created the cart page, added just one add to Cart button to my catalog page and everything worked. Then I added the checkout pages. UE never opened but I can deal with that.

I added one product to my cart. Good so far. Then I completed the checkout page, punched the checkout button and this is what showed up on the confirm page browser window "Unknown column 'IP9016' in 'field list'".

IP9016 is the product ID for the one product for which I added the "add to cart" button. Where do I find this demon "Unknown column" and where is the "field list"? And how do I get passed this?

Guess I'm not really expecting help, but any would be greatly appreciated. Next step is to dump eCarte and find something else.

Nothing shows up that I can see in either the browser source or in the source code in DW. I'm probably just not knowledgeable enough to know what I'm looking for. I placed the code you gave me at line 1 in both the checkout and confirm pages. Nothing changes that I can see.

I'm using PHPmySQL/MAMP as a test environment on my local site. I have only to complete the shopping cart function and then I can upload to my host server. Is there something I can attach that will help you, or can I have you link directly to my local site (don't even know if that's possible)?