Create an array from another array

[toe_head2001]

If have and array called food (generated by form checkboxes) in which each items in that array is in its own mysql database row with another entry called price. I would like to create a second array for the prices.

I have written this code to display each price of all the item in my food array.
Having them list is fine, but I would like them to be in an array so I can easily add them up. How can I change it so it will put all the prices into an array.



foreach($food as $foodarray) {

$result = mysql_query("SELECT * FROM menu WHERE name='".$foodarray."'");

while($row = mysql_fetch_array($result))
{
echo $row['price'], " ";
}
}


Thanks.

[JasonDFR]

If have and array called food (generated by form checkboxes) in which each items in that array is in its own mysql database row with another entry called price. I would like to create a second array for the prices.

I have written this code to display each price of all the item in my food array.
Having them list is fine, but I would like them to be in an array so I can easily add them up. How can I change it so it will put all the prices into an array.



foreach($food as $foodarray) {

$result = mysql_query("SELECT * FROM menu WHERE name='".$foodarray."'");

$price = array();

while($row = mysql_fetch_array($result))
{
$price[] = $row['price'], " ";
}
}


Thanks.

See changes above.

[toe_head2001]

Thanks man. I had to tweak it a little, but it does what I want it to do.



$price = array();

foreach($food as $foodarray) {

$result = mysql_query("SELECT * FROM menu WHERE name='".$foodarray."'");

while($row = mysql_fetch_array($result))
{
$price[] = $row['price'];
}
}

echo array_sum($price);

[JasonDFR]

Cool. Yeah I edited the code you posted pretty quickly and it wasn't right, but what you ended up with is right on.