jptechnical Posted August 12, 2005 Share Posted August 12, 2005 I have searched the forums with little result. I have a shopping cart with about 100 orders before the credit card started getting split and half sent via email. I would like to purge those saved credit cards without having to do it by hand. I don't really understand sql queries, I am sure I could learn, but I have so many other projects it would take less time to just purge them by hand. I was hoping someone might be able to suggest a sql query I can run from phpMyAdmin. Or perhaps a php script to run from time to time to purge the records. I appreciate any help you can offer. Link to comment Share on other sites More sharing options...
FalseDawn Posted August 12, 2005 Share Posted August 12, 2005 What exactly do you want to do? Just blank out the credit card details for these orders (if so, what are the fields?), or delete orders (and associated child records) for orders where the credit card data was stored in full? You can't expect anyone to be confident in writing a query to help you with such a wishy washy requirement definition. Link to comment Share on other sites More sharing options...
Rob123 Posted August 12, 2005 Share Posted August 12, 2005 Seek and ye shall find.... :) http://www.oscommerce.com/forums/index.php?showtopic=126898 HTH, Robert Link to comment Share on other sites More sharing options...
jptechnical Posted August 12, 2005 Author Share Posted August 12, 2005 Seek and ye shall find.... :) http://www.oscommerce.com/forums/index.php?showtopic=126898 HTH, Robert <{POST_SNAPBACK}> Man, that is exactly what I need. I really didn't know the right search terms I guess. I think I remember you helping me out in the past Robert, a very memorable avatar! Thanks alot, I am good to go. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.