calculate price..HELP!

[alexz]

Hi I am doing a flash project in which I have to use PHP and MySql to calculate the prize of the items that user has selected. How do I do that in php??

[maxpup979]

$total=$price1+$price2;
or if you are storing items in an array--
foreach($price as $item){
$total=$total+$item;
}

[alexz]

Thanks.. However..The problem is that it all depends on what items the user decides to pick. Do I have to use a switch then? How would I write that switch? Also the prices are in a mysql database. How do I retrieve the price from the database in that switch?

[alexz]

Thanks.. However..The problem is that it all depends on what items the user decides to pick. Do I have to use a switch then? How would I write that switch? Also the prices are in a mysql database. How do I retrieve the price from the database in that switch?

[maxpup979]

what kind of data structure are you using?...can you show some code? Are you assembling the cart items in an array?...

all you would need to do to get the price out of the db is follow the same structure as before--
instead of just doing the total, you can run queries against the database to get the price per item (not really very efficient, but it works), and then total them....or you can have the total returned by the query...use the sum function