PHP - MySQL ve e-posta veri Çekme

0 Cevap

Aşağıdaki kodda, ben phpMyAdmin ile sql çalıştırabilir ve bir sonuç dönecektir. Bu tarayıcı üzerinde herhangi bir php hataları atmak değil. Ben e-posta göndermek için almak gibi olamaz.

<?php
ini_set('display_errors',1);
 error_reporting(E_ALL);
include('database.inc.php'); // Our database connectivity file
?>
<?php
$reminder_date = "t1.`reminder_date`";
$email = "t1.`reminder_email`";
$reminder_name = "t1.`reminder_name`";
$reminder_details = "t1.`reminder_desc`";
$server = "reminder@teamcrr.com";

$sql = "SELECT t1.`reminder_id` , t1.`reminder_name` , t1.`reminder_desc` , t1.`reminder_date` , t1.`reminder_email` , lp4.`email` AS `lp_reminder_email`
FROM `reminder_events` AS t1
LEFT OUTER JOIN `authorize` AS lp4 ON ( t1.`reminder_email` = lp4.`email` )
WHERE reminder_date <= NOW( )
ORDER BY `reminder_date` ASC";

$result = mysql_query($sql) or die(mysql_error());

while( $row = mysql_fetch_array( $result ) )
?>
<?php
 $to = "$email";
 $from = "$server";
 $headers = "$from";
 $subject = "$reminder_name";
 $body = "$reminder_details";


 {
 $send = mail($to, $subject, $body, $headers);
 }

 ?>

Anyone tell me what I'm doing wrong? Thanks.

0 Cevap