Re: Multiple database seeking
| From: | Valentin V. Petruchek | Date: | Mon, 03 Dec 2001 15:08:52 +0000 |
| Subject: | Re: Multiple database seeking | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76381@lists.php.net to get a copy of this message | ||
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?" <alen.nonkovic@uni-mb.si>
To: <php-general@lists.php.net>
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