Allen,
Have you a table of recipes, like so:
recipe1 item1
recipe1 item2
...
recipe1 itemn
recipe2 item1
You could then fetch all the items for a given recipe, and loop through the
returned results (an array), concatenating the prices.
Alternately, you store all your items in an array for
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]] =
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
3 matches
Mail list logo