Multiple database seeking
| From: | Alen Nonkovič | Date: | Mon, 03 Dec 2001 14:31:03 +0000 |
| Subject: | Multiple database seeking | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76377@lists.php.net to get a copy of this message | ||
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