Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

need help wording an SQL delete statement.


Guest

Recommended Posts

In the process of uploading my products with EasyPopulate, changing my categories and re-uploading, I have created many products that exist in 2 categories. I know that the products_to_categories table is where this is contained. Because there are many of these products that when now exist in categories_id 14 & 8, for example, and I would like to remove the entries where they exist in both. Or even better, if the product exists in both, remove it from categories_id 8.

Did I mention I'm not good with SQL queries yet? If anyone can throw a statement my way, I would be very grateful.

 

sirkyle

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...