Computing Markup Formula and updating all rows

Ibn_Saeed

I am new to Forum and this is my first post.

I am trying to edit my shopping cart.

I have three tables which I am working on

Table = products

Fields:
1). products_price
2). products_cost
3). products_markup

First, i want to enter One Value in products_markup(it should work globally). I have done that with the following command

$db->Execute("update " . TABLE_PRODUCTS . " set
			products_markup='" . db_input($_POST['products_markup']) . "' ");

------------------

So for e.g. i want 60% markup to be applied on all the products, i run the above code.

Now this is where i am getting stuck. Now i want the same global markup which i applied above, to calculate the markup based on the values stored in my products_cost table (which is filled in with values beforehand).

So products_markup should calculate itself with products_cost and automatically update the all products_price rows. I tried with the following code but it does seem to work, the calculation is done fine but it takes the first value from products_markup and products_cost rows and calculates the markup and updates all the products_price rows from the calculation from the first row of products_markup and products_cost.

So for e.g. in the first row
products_cost = 150
products_markup = 90
it changes the products_price to 285.
And the same value 285 gets updated in all the rows of products_price.

Whereas I need the values to change according to the different values in products_cost row.

$products_cost_query = $db->Execute("select products_id, products_cost from " . TABLE_PRODUCTS . "");
	$products_id= $products_cost_query->fields['products_id'];	
	$products_cost= $products_cost_query->fields['products_cost'];	
 products_cost_q = $db->Execute("select products_cost from " . TABLE_PRODUCTS . "");

$products_price = ((($products_cost * $products_markup)/100) + $products_cost);


$db->Execute("update " . TABLE_PRODUCTS . " set
		products_price='" . $products_price . "'  ");

Even though the SQL statement works in MySQL Query software.

update products 
set products_markup=100, 
products_price = (((products_cost * all_products_markup)/100) + products_cost)
;

This mysql command works and it updates accordingly but when i try to implement it in the php file, it does not work as intended

Weedpacket

Why not just use the MySQL implementation, since that is known to work? That is,

$db->Execute("update products 
set products_markup=100, 
products_price = (((products_cost * all_products_markup)/100) + products_cost)");