Jump to content


Corporate Sponsors


Latest News: (loading..)

pafranklin

Member Since 04 Oct 2005
Offline Last Active Jan 26 2012, 18:18
-----

Topics I've Started

MySQL Script

26 January 2012, 06:48

Hi there,

I am trying to write a MySQL query to update a field in the products table for products only in a certain category. However with the products_id and categories_id only linked in the products to categories table, how can I do this?

So far I have the following:

UPDATE products SET products_availability_id = '5' where products_to_categories category_id = '22'

I am trying to update the field products_availability_id in the products table but only for products in category 22..........

Any help would be appreciated!

Paul