Originally Posted by oku

Been lookin at that php mail function today - was able to send a simple email using the examples that are provided

still figuring out how to email results from my query to be sent via email

ive structured a script below - it doesnt work but you can see what i am after

Help with Code Tags

(Toggle Plain Text)

<?php

$host = "localhost"; 
$user = "user_name"; 
$pass = "password"; 
$db = "domains";


mysql_connect($host,$user,$pass) or die("ERROR:".mysql_error());
mysql_select_db($db) or die("ERROR DB:".mysql_error()); 

$query="SELECT domain_name FROM domains WHERE exp_date > NOW()+7 ORDER BY domain_name ASC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();


$i=0;
while ($i < $num) {

$id=mysql_result($result,$i,"id");
$domain_name=mysql_result($result,$i,"domain_name");
$company_name=mysql_result($result,$i,"company_name");
$simply_account=mysql_result($result,$i,"simply_account");
$notes=mysql_result($result,$i,"notes");
$exp_date=mysql_result($result,$i,"exp_date");



$to      = 'daniel.whiteside@googlemail.com';
$subject = 'Domain renewall reminder';
$message = '


The following domains will expire in 7 days

<BR><BR>

$domain_name - $company_name<BR>

<BR><BR>

Dont forget to renew!<BR><BR>

Domain Team


';
$headers = 'From: oku@sutsurikeru.net' . "\r\n" .
    'Reply-To: oku@sutsurikeru.net' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);
?>

<?php $host = "localhost"; $user = "user_name"; $pass = "password"; $db = "domains"; mysql_connect($host,$user,$pass) or die("ERROR:".mysql_error()); mysql_select_db($db) or die("ERROR DB:".mysql_error()); $query="SELECT domain_name FROM domains WHERE exp_date > NOW()+7 ORDER BY domain_name ASC"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $id=mysql_result($result,$i,"id"); $domain_name=mysql_result($result,$i,"domain_name"); $company_name=mysql_result($result,$i,"company_name"); $simply_account=mysql_result($result,$i,"simply_account"); $notes=mysql_result($result,$i,"notes"); $exp_date=mysql_result($result,$i,"exp_date"); $to = 'daniel.whiteside@googlemail.com'; $subject = 'Domain renewall reminder'; $message = ' The following domains will expire in 7 days <BR><BR> $domain_name - $company_name<BR> <BR><BR> Dont forget to renew!<BR><BR> Domain Team '; $headers = 'From: oku@sutsurikeru.net' . "\r\n" . 'Reply-To: oku@sutsurikeru.net' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($to, $subject, $message, $headers); ?>

Not sure where i am going wrong