Model sharing variables in functions? [solved]

[eluser]xwero[/eluser]
The get_products query seems very odd are you sure you didn't forget a part of the code?

I assume the products.pDesignerId isn't the same as the designer.dDesignerId.

But to get the rate in the get_royalty_rate you have to return $row->dPercentages instead of $query->result() and then you can do this in the get_products method

Code:

$this->db->select('pSku,pName,oPrice,oSku,rTimeStamp, sum(oQuantity) as quan, ((oPrice*' . $this->get_royalty_rate($id) . '/100)*sum(oQuantity)) as salesProfit');