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,

----- Original Message -----
From: "Alen Nonkovi?" <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 4:31 PM
Subject: [PHP] Multiple database seeking


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

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 ;)


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to