Hello Boys,
[color=#333333][font=arial, sans-serif][size=4]I update[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]the prices of[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]the “[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]cog[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]”[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] on table[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] ([/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]cscart_products[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]) by calculating the[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]30[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]%[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]([/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]less)[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]from the field price on table[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] ([/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]cscart_product_prices) WHERE company_id='11'[/size][/font][/color]
[color=#333333][font=arial, sans-serif][size=4]Some of you[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]I[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]can[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]'[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]help on how to[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]write[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]the query[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]to be written[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]?[/size][/font][/color]
[color=#333333][font=arial, sans-serif][size=4]excuse me[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4],[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]but I'm not[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]an expert[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]…[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]I[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]still[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]like to[/size][/font][/color][color=#333333][font=arial, sans-serif][size=4] [/size][/font][/color][color=#333333][font=arial, sans-serif][size=4]dabble[/size][/font][/color]
I don't know what you mean by “prices of the cog”, but here goes:
UPDATE cscart_products SET cogprice = (SELECT price FROM cscart_product_prices WHERE product_id = product_id) * 0.7 WHERE compay_id='11'
Substitute “cogprice” for whatever field it is in cscart_products that you are trying to update. Every other table/field name in this query is correct.
You should make a backup first before you try to run any SQL query.
Thank'you STELLAR …very mutch
But i have one problem: I have correct the field name:
UPDATE cscart_product_cogs SET cog = (SELECT price FROM cscart_product_prices)* 0.7 WHERE (SELECT company_id FROM cscart_products)='11'
I have NO-ERROR, but, NO MODIFY ( [color=#000000][font=sans-serif][size=3]0 righe modificate. ( La query ha impiegato 0.0021 sec )[/size][/font][/color]
Sorry, I am not familiar with 'cscart_product_cogs', it certainly isn't in my 2.2.3 nor 2.2.4 CS-Cart database, nor can I find any information on that table.
However, I think the last WHERE condition is incorrect, try:
[code
UPDATE cscart_product_cogs SET cog = (SELECT price FROM cscart_product_prices)* 0.7 WHERE (cscart_products.company_id = '11')
```