i can send mail to destination, but the output of mysql cant send with the mail().
PLz tell me why ?
thx
<?
include ('book_sc_fns.php');
session_start();
if (session_is_registered("valid_user"))
{
$link_ID = mysql_connect("localhost","root","fantasy");
mysql_select_db("book_sc");
$str="SELECT * FROM orders join customers join order_items join books join member WHERE member.email='$valid_user' limit 1;";
$result=mysql_query($str,$link_ID);
//mysql_close($link_ID);
$records=mysql_fetch_row($result);
$email = $valid_user;
$from = "From: administator@test.com \r\n";
$mesg = "Payment Details: Name:$name
Address: $address
City/Suburb: $city
State/Province: $state
Postal Code or Zip Code: $zip
Country: $country
Shipping Details: Name: $ship_name
Address: $ship_address
City/Suburb: $ship_city
State/Province: $ship_state
Postal Code or Zip Code: $ship_zip
Country: $ship_country
Ordered items: Product code: $isbn ";
if (mail($email, "Order Confirmation", $mesg, $from))
return true;
else
return false;
}
?>
