18 May 2007, 12:39 PM
New Zenner
- Join Date:
- Mar 2007
- Location:
- sunny Florida, USA
- Posts:
- 80
- Plugin Contributions:
- 0
removing all references to 'manufacturer'
Hi all,
At the whim of the client, I need to remove all references to 'manufacturer' on the cart site. I believe that if I issue the following SQL command in MyAdmin, it'll do the trick (yes, I will definitely make a complete db backup first :smile: ).
Would one of the more experienced zenners out there confirm, please, that I'm either right or foolish? :blush:
update `products`
set `manufacturers_id` = 0 where `manufacturers_id` <> 0
I know this probably isn't the cleanest way to do it, but as always, time is an issue.
Thanks in advance,
~Ray
BouncerFL