building a mail from the db
Posted: Thu Jan 19, 2006 4:58 am
twigletmac | Using
The above code won't work as it see's the query and the rest as errors. Any ideas?
Code: Select all
tags makes syntax errors easier to spot.[/color]
I need to build a mail with results from the database.Code: Select all
$mesg = 'THIS IS AN ORDER FOR '.$fr['q'].' COMPUTER(S)'."\r\n"
."\r\n".'Ex VAT: '.$fr['exvat'].''."\r\n"
."\r\n".'Price: '.$fr['price'].''."\r\n"
."\r\n".'Bulk Discount: '.$fr['discount'].''."\r\n"
."\r\n".'Total ex VAT: '.$fr['totalexvat'].''."\r\n"
."\r\n".'Total Order Price: '.$fr['total'].''."\r\n"
."\r\n".''."\n".'Order Number: '.$SR."\r\n"
."\r\n".'Title: '.$fr['title']."\r\n"
."\r\n".'Full Name: '.$fr['fullname']."\r\n"
."\r\n".'Email: '.$fr['username']."\r\n"
."\r\n".'Payment Method: '.$fr['payment']."\r\n"
."\r\n".'Home Tel: '.$fr['hometel']."\r\n"
."\r\n".'Work Tel: '.$fr['worktel']."\r\n"
."\r\n".'Mob Tel: '.$fr['mobtel']."\r\n"
."\r\n".'Date: '.$today."\r\n"
."\r\n".'Address 1: '.$fr['daddress1']."\r\n"
.'Address 2: '.$fr['daddress2']."\r\n"
.'Address 3: '.$fr['daddress3']."\r\n"
.'Town/City: '.$fr['dtown']."\r\n"
.'County: '.$fr['dcounty']."\r\n"
.'Post Code: '.$fr['dpostcode']."\r\n"
.'Delivery details: '.$fr['deldet']."\r\n"
$build_mail = "SELECT * FROM categories,orders_products WHERE caegories_category_id=orders_products.category_id AND orders_products.orderno='$SR'";
$bq = mysql_query($build_mail, $db_conn) or die("Query $build_mail Failed".mysql_error());
while ($br = mysql_fetch_assoc($bq))
{
."\r\n".''.$br['category_name'].': '.$br['description'].''."\r\n"
}
mail($emailto, $subj, $mesg, $additional_headers)or die('mail not sent');