Use smth like this ->
$need_prices = '01,02';
$prices = new Array();
$sql = "select * from price_list where id in ($need_prices)"
$result = mysql_query ($sql);
{//cycle while $result is not empty - for every record
$row = mysql_fetch_array($result);
$prices[$row["id"]] = $row["price"];
}
After this you'll get array of prices $prices - indexes are id value. so u
can write
$new_price1 = 2*$prices[1] + $prices[2]
Zliy Pes, http://www.zliypes.com.ua
----- Original Message -----
From: "Alen Nonkovi?" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 4:31 PM
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]
