multpling cookie values

[Anon]

<?php
// Get the description of the selected items
// Generate the query
$query= "select * from catalog where " ;
for($i=0; $i<$total_items; $i++)
if ($i == ($total_items-1))
$query .= "cat_id = '$items_tray[$i]' " ;
else
$query .= "cat_id = '$items_tray[$i]' or " ;
if (!($result1 = mysql_db_query($DB,$query))) {
DisplayErrMsg(sprintf("internal error %d:%s\n",
mysql_errno(), mysql_error()));
exit() ;
}
// Display item info resulted by query
$j= 0 ;
while(($row = mysql_fetch_array($result1))){
?>
This code loops though a cookie and pulls the values $price and $qty. I take these values and multiplie them and store them in $s_total

$s_total = $qty * $price;

if the result find three items in the cookie I want to add those three items $s_total together to get a grand total

If amy one can help
TIA
Richie TM

[Anon]

Make ur question clear please 🙁

[Anon]

OK the cookie is holding the values $cat_id which repersents and item stored in a database (MySQL) and the value qty. using the $cat_id stored in the cookie I use it to pull the values $price so if a user chooses 3 items the cookies is holding three $cat_id and I have three $price and three $qty. I take these values and multiply them

$s_total = $row[price] * $qty;

so if I disply them it looks like this

|price |qty|total
1.| 23.00 | 2 |46.00
2.| 33.00 | 1 |66.00
3.| 21.00 | 1 |42.00

What I want to do is add the $s_totals together to get a grand total.

Hope that clear.
TIA
Richie TM