Guest Posted July 4, 2003 Posted July 4, 2003 OK I deleted (or tried to) a category of mine that had about 1700 products underneath it that I also wanted deleted too. Didnt go as well as expected and OSC removed the categories but decided 1700 products was too much for it and died. It wasn't too much of a big deal because all of the products are from one wholesaler and I use a code in the model number to determine where the products is from. So I went in phpmyadmin in the products table and deleted them like: DELETE FROM `products` WHERE 1 AND `products_model` LIKE 'SGA%' That worked fine. BUT now I just noticed I have 1700 extra product descriptions. :oops: So does anyone know of a way to get the products and descriptions to jive. I have a feeling that while the site seems to be running ok, this will cause me a problem sooner or later. Thanks and Happy 4th!
Guest Posted July 4, 2003 Posted July 4, 2003 Query whether there is a products_id in the products table that matches the products_id in the products_description... if no match then delete
Guest Posted July 4, 2003 Posted July 4, 2003 I was thinking it might be something like that, but my mysql skills arent that good. One the same table Im ok, but still seem to screw up when another is involved. Any rough format would be appreciated!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.