Hello, I am trying to make a something like a cooking recipe with some calculations. My problem is too much database querying. Is it really a problem???
Let's suppose there is a table with items and prices: item1 price1 item2 price2 item3 price3 ... Then I have to calculate some new indegrient price, which is a result of calculating other prices: (ex: $new_price1 = 2*$price1 + $price2 ) To get wanted prices I used standard query: ---------------------------------------------------- $result = mysql_query ("SELECT price from price_list where id = '01'"); $row = mysql_fetch_array($result); $price1 = $row["price"]; $result = mysql_query ("SELECT price from price_list where id = '02'"); $row = mysql_fetch_array($result); $price2 = $row["price"]; //...and so on for about 30 indegrients. And on the end: $new_price1 = 2*$price1 + $price2; print "$new_price1"; ---------------------------------------------------------- But, is there a quicker way to do this? Am I doing maybe the wholistic mistake in process? Or this is just OK? Please, help cooking the soup ;) regards, Alen