Email results from a query

gvp16 · April 30, 2008

Hi, im trying to send an automated email that contains order details called from a database, this is what i have :

<?include("conninfo.php");

session_start();

$randid=$_SESSION["randno1"];

$orderref=$_GET["orderref"];

$query=("SELECT * from basket where randid like $randid ");

$result5=mysql_query($query) or die ("couldnt do it!");

while ($r=mysql_fetch_array($result5))

{

$items=$r["itemno"];

$date=date('d/m/Y');

$email=$r["email"];

$randid=$_SESSION["randno1"];

$status="Pending";

$font=$r["font"];

$info1=$r["info1"];

$info2=$r["info2"];

$info3=$r["info3"];

$info4=$r["info4"];

$info5=$r["info5"];

$info6=$r["info6"];

$total=$r["total"];

$ST=$_GET["ST"];

$weight=$r["weight"];

$postage=$r["postage"];

$notes=$r["notes"];

$query = mysql_query("INSERT INTO orders(orderno,items,date,email,status,total,weight,postage,font,info1,info2,info3,info4,info5,info6,notes) VALUES ('$orderref','$items','$date','$email','$status','$total','$weight','$postage','$font','$info1','$info2','$info3','$info4','$info5','$info6','$notes')");

}

$query1 = mysql_query("INSERT INTO orderdetails(orderno,date,email,total,status) VALUES ('$orderref','$date','$email','$total','$status')");

$query2 = mysql_query("DELETE FROM basket WHERE randid='$randid'") or die("Couldn't1");

ini_set("sendmail_from", " sales@*****com ");

$headers = "From: sales@*****.com\r\n";

$headers .= "Reply-To: sales@*****.com\r\n";

$headers .= "Return-Path: sales@*****.com\r\n";

$headers .= "MIME-Version: 1.0\r\n";

$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";

$subject = "BetaGifts.com Order $orderno";

$message = "<html><body>";

$message .= "<h1> Order $orderref</h1><br><br>";

$message .= " Dear Customer, Thank You For Your Order, <br><br>";

$message .= "Your Current Order Status is: $status <br><br>";

$message .= "<table bgcolor=#909091>";

while($result5=mysql_query($query)){

$message .= "<tr>";

$message .= "<td>";

$message .= "$items $font $info1 $info2 $info3 $info4 $info5 $info6";

$message .= "</td>";

$message .= "</tr>";

}

$message .= "</table><br>";

$message .= "Order Total £$total<br>";

$message .= "Notes $notes<br>";

$message .= "<i> Please Expect Delivery of Your Item Within 7 Working Days, All Items Are Sent Using Recorded Delivery</i><br>";

$message .= "</body></html>";

mail($email, $subject, $message, $headers,"From: [email protected]");

header("location:index.php");

?>

i want the while() to loop so that is includes all the items from the order

Sign In

Email results from a query

Recommended Posts

gvp16

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information