I need to do this in mysql
UPDATE products
SET products.instore = '4'
WHERE products.id = store4.id
What I am trying to do is find all of the products that are in the store4 table. Once I find a product, i want to update it's "instore" field to reflect that it is in store4, by setting it equal to '4'
any ideas.
like my last post, i could use some really good documentation on using mysql.
paul
UPDATE products
SET products.instore = '4'
WHERE products.id = store4.id
What I am trying to do is find all of the products that are in the store4 table. Once I find a product, i want to update it's "instore" field to reflect that it is in store4, by setting it equal to '4'
any ideas.
like my last post, i could use some really good documentation on using mysql.
paul