contents of a shopping cart in an email

Anon

Hi, i would like to send the contents of a shopping cart to an e-mail address.
I use a shoping cart class and i get my products,prices and qty throw a while loop.
First i get the id's of the products, then i select name,price,qty from db for that products. Now i want to put that output in mail function in $body.
any idea
TX a lot

cordex

Sure. in your while loop stick a

$body .= <insert stuff you want to put into $body here>

and it will add it onto the end of what you currently have in $body.

Anon

Tx a lot, it worked.
But now i have another q.
Some products in my shop cart have multiple types equals multiple prices.
In my db i have a single id for that product and i have 3 fiels : price1 price2 price3.
Now i don't know how to extract with my shop class the price for that product based on id and type.
At the moment i extract the price based onlyon id.
Any ideea TX

cordex

I don't know if I understand you.

But ... maybe ...

if $type is an int from 1-3 depending on the price

$query_st = "SELECT * FROM table WHERE id='$id'";
$query_rs = mysql_query($query_st);
$query_ar = mysql_fetch_array($query_rs);
$pricetype = "price" . $type;
$price=$query_ar[$pricetype];

gzaro

Hi.
I use a shopping class that has an add, clear, total functions and has 3 variables items, total an i added type. I have a function that get's all id's and stores them in an variable.
Oh... my shoping cart is based on MyMarket example on devshed.com

My problem is that when i want to get the price from db i get the price based on the last type i cliked.

If you know MyMarket maibe you can give me some tips. Now i'm tinking to add the type, in $this->items[$type] like the id of the product.