deleted table and re added need help still.

[Guest]

Ok, thanks for the sql to recreate the table. I pasted it and it works. I went through the cart and purchased the product, it shows in the table.

 

But here is a new problem. I ran a query to export the orders and orders_products. and the product i just ordered shows up on all of the records that were there previous to me deleting the table with my order id. How do I retrieve the old information and run this query again. The records are still in my shopping cart and in the orders table but I don't want them to show my recent order id.

 

One more question, when I go through my shopping cart process, it displays the credit card i used on all computers when I enter in the first number, how do I hide that?

[♥mdtaylorlrim]

Ok, thanks for the sql to recreate the table. I pasted it and it works. I went through the cart and purchased the product, it shows in the table.

 

But here is a new problem. I ran a query to export the orders and orders_products. and the product i just ordered shows up on all of the records that were there previous to me deleting the table with my order id. How do I retrieve the old information and run this query again. The records are still in my shopping cart and in the orders table but I don't want them to show my recent order id.

 

One more question, when I go through my shopping cart process, it displays the credit card i used on all computers when I enter in the first number, how do I hide that?

Most important thing is, DO NOT USE the credit card module that comes with osCommerce. It is for testing only. Open an account with USAePay or some other merchant provider that has a drop in payment module for osCommerce. That is just one, there are tons more.

 

Simply delete the order you made then import your data back into your orders table from your csv file using phpMyAdmin.