help with shopping cart and multi bcc

[kb9yjg]

Hello,

I am working on a shopping cart for a site. I am having a bit of a problem and dont know where to go from here. As a person fills out their information on the order form there is a check box there to send a copy of their order to their email address. This works fine along with a carbon copy to the owner of the site. The problem that I have is that this shopping cart is going to be selling many different products from many different vendors. Idealy I'd like in the bcc of the email that gets sent out to have the email address of each vendor that the person chose from so that they can start processing shippments etc. For instance A person picks a dress from vendor a, a scarf from vendor b and so on. Id like to have these email addresses drawn from a vendor table and get these vendors a copy of the order. Is this possible and if so how hard is it to accomplish?

Thanks for your help. This is kind of a time sensitive project so your express and sincere help is greatly appreciated.

Sincerely;

Jason

[jannoy]

must have a queries to select which BCC should be sent, base n the clients product

like :
$cartquery=msyql_query("select from cart_table where id='$sid' ");
while ($tempresult=mysql_fetch_object($cartquery)) {
$id=$tempresult->id;
$query=mysql_query("select from cart_table INNER join vendors on cart_table.id=vendors.id where cart_table=$id ") or die (mysql_error());

$result=mysql_fetch_object($query);
$email=$result->emailtable;

}

// now process email BCC here after checkout

[kb9yjg]

Hey Thanks for your help hopefully that code snippet works out. Your help is greatly appreciated!

Jason