Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

delete credit details


Guest

Recommended Posts

Posted

Is there a way to delete the cc details of an order?

Posted

You shouldn't record them in the first place :-)

 

If you want to delete all the cc details you hold, run some sql on you db to update the fields concerned to space or zero.

 

See http://www.w3schools.com/sql/sql_update.asp to learn how to write some sql or read below.....

 

update orders SET cc_number = ''

 

or

 

update orders SET cc_number = '' where orders_id = 123456

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted
You shouldn't record them in the first place :-)

 

If you want to delete all the cc details you hold, run some sql on you db to update the fields concerned to space or zero.

 

See http://www.w3schools.com/sql/sql_update.asp to learn how to write some sql or read below.....

 

update orders SET cc_number = ''

 

or

 

update orders SET cc_number = '' where orders_id = 123456

 

I have been in business for a few years and when you have a merchant account you need to know peoples details to charge them.

Posted

Thanks for that code. Have inserted it in a few places but really have no idea where to specifically put it. :'(

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...