emailing product details

[g7pwx]

Ok i have kind of a shopping cart i can add products to the cart but i need to email this selected informtaion to an email address.

heres part of the code

$to="[e-mail]";
$from_email="Order Enquiry";
$header="Order";
$info="An order has been placed. $price. $item The order ID is $tran_ID.";


mail($to,$header,$info);

This will email me the info including the order id ($tran_ID) i need it to send the price and item in the email pulled from the database. if you need to see all the code to the mail script i can send it.

I hope i made clear wat i am trying to do, i know this is a simple problem but i just cant see it

any help will be greatly received.

Thanks.

[khaldryck]

this seems good to me, i don't catch the problem.

if the problem is that it don't send price and other information, then it's not the mail function that pose problem but the query or the way you put the result in your variable $price,
$item and $tran_ID

instead of trying to mail it, you can simply make an echo of the $info.
if the mail is not send at all, it could be a problem outside PHP.

[g7pwx]

No i can email but the problem i am having even if i echo $info no price comes up.

heres the full mailit script

include ("c_conn_inc.php");
session_start();
$sql="SELECT * FROM order_line WHERE order_ID='$tran_ID'";
$mysql_result=mysql_query($sql,$connection);
$num_rows=@mysql_num_rows($mysql_result);

$to="[e-mail]";
$from_email="Order Enquiry";
$header="Internal Stationary Order";
$info="An order has been placed. $price. $item The order ID is $tran_ID.";


mail($to,$header,$info);
echo "Thank-you for your product enquiry.  $price
For your information your Order/Transaction ID is $tran_ID. <BR>";

mysql_close($connection);
session_unset();
session_destroy();

whatever i do i cant get it to echo or display the $price or $item from the database to include it in the email.

Thanks.

[khaldryck]

that's because you don't fetch your result into the variables.

do this :

include ("c_conn_inc.php");
session_start();
$info="An order has been placed.\n";
$to="[e-mail]";
$from_email="Order Enquiry";
$header="Internal Stationary Order";
$total=0;
$sql="SELECT * FROM order_line WHERE order_ID='$tran_ID'";
$mysql_result=mysql_query($sql,$connection);
$num_rows=@mysql_num_rows($mysql_result);
while($arr=mysql_fetch_array($mysql_result)) {
   $info.=$arr["price"].". ".$arr["item"]."\n";
   $total+=$arr["price"]
}

$info.="Total of your order : ".$total.".\nThe order ID is ".$tran_ID;


mail($to,$header,$info);
echo "Thank-you for your product enquiry.  $total
For your information your Order/Transaction ID is $tran_ID. <BR>";

mysql_close($connection);
session_unset();
session_destroy();

i just wrote it fast, so it's not bugfree, but the idea is in there.

[g7pwx]

thanks i kinda adapted it to work but u put me on the right track