capturing details to email

[g7pwx]

Ok i got this to send me product details to the email but if there is only 1 item selected it works fine if there is 2 items selected it only displays the last item in the list

heres the code

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);
while ($row=mysql_fetch_array($mysql_result))
{
$system_type=$row["system_type"];
# display results
$ID=$row["ID"];
$tran_ID=$row["order_ID"];
$item=$row["item"];
$qty=$row["qty"];
$price=$row["price"];
}
$to="me@me";
$from_email="Order Enquiry";
$header="Internal Stationary Order";
$info="An order has been placed. Product code=.$price. Product=$item Quantity=$qty 
The order ID is $tran_ID.";

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

i need more than 1 item to show in the email. any ideas?

thanks

[Christian_B_]

You have to define $info inside the while-loop like

while ($row=mysql_fetch_array($mysql_result))
{
$system_type=$row["system_type"];

display results

$ID=$row["ID"];
$tran_ID=$row["order_ID"];
$item=$row["item"];
$qty=$row["qty"];
$price=$row["price"];

$info .= "An order has been placed. Product code=.$price. Product=$item Quantity=$qty
The order ID is $tran_ID.";

}

[xblue]

you keep overwriting your variables.

what you could to is appending to $info instead.

$info="An order has been placed.\r\n";

while ($row=mysql_fetch_array($mysql_result))
{
# display results
$info.="Product code=".$row["price"];
$info.=" Product=".$row["item"];
$info.=" Quantity=".$row["qty"]."\r\n";
}
// I assume you want that only once?
$info.="The order ID is ".$row["order_id"].".";

[khaldryck]

you need to use array if you want to store more than one value into the same variable

the exemple i gave you in the other post was constructing the $info right in the loop.

session_start();
$info='';
$sql="SELECT * FROM order_line WHERE order_ID='$tran_ID'";
$mysql_result=mysql_query($sql,$connection);
$num_rows=@mysql_num_rows($mysql_result);
$i=0;
while ($row=mysql_fetch_array($mysql_result))
{
$system_type=$row["system_type"];
# display results
$ID[$i]=$row["ID"];
$item[$i]=$row["item"];
$qty[$i]=$row["qty"];
$price[$i++]=$row["price"];
}
$to="me@me";
$from_email="Order Enquiry";
$header="Internal Stationary Order";
for($j=0;$j<$i;$j++) {
  $info.="An order has been placed. Product code=.$price[$j]. Product=$item[$j] Quantity=$qty[$j] 
The order ID is $tran_ID.\n";
}
mail($to,$header,$info);
echo "Thank-you for your product enquiry.
For your information your Order/Transaction ID is $tran_ID. <BR>";
echo nl2br($info);
mysql_close($connection);
session_unset();
session_destroy();

i droped one line in the while :

$tran_ID[$i]=$row["order_ID"];

this row is no use as you already know $tran_ID (used in your query), so drop it

i prefer the other method which constructed the lines so it was better presented in the mail. but this exemple will work also
the echo nl2br($info) will be changed to mail($info) instead.
in mail \n is the newline, not in html.

[g7pwx]

that works great thanks. got a bit of formatting to sort out but it works great.

Thanks for your help.