Something like this for the SQL SELECT ( t1.price + t2.price ) as total FROM table t1, table t2 WHERE t1.id=1 AND t2.id=5;
Jason Lotito [EMAIL PROTECTED] www.NewbieNetwork.net > -----Original Message----- > From: Alen Nonkovič [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 03, 2001 9:31 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Multiple database seeking > > > 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 > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
