dootch Posted December 11, 2003 Share Posted December 11, 2003 For most on this list this is a no brainer but I struggled with this so I put this out there for all newbies.This will help those of you with alot of customers in you DB. Go to phpmyadmin select your database, click on the customer table, select SQL from the top tab. Copy and paste this code into Phpmyadmin and click go. This takes subscribers (1) to 2, manually change yours to 1 to test and reverse #'s 1 and 2 and run again to change back. Update IGNORE customers set customers_newsletter='2' WHERE customers_newsletter='1'; Link to comment Share on other sites More sharing options...
ChrisHoward Posted December 17, 2003 Share Posted December 17, 2003 Nice one for adding this MySQL code it may come in handy top me one day :D Link to comment Share on other sites More sharing options...
azer Posted January 3, 2004 Share Posted January 3, 2004 thnaks for this trick ! MS2 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.