Pozdrav!
Već sam pisao vezano za php podsjetnik ali sad imam drugi problem. reminder_send je skripta koja bi trebala slati dospjele podsjetnike. sve je u redu dok treba slat podsjetnike na jedan mail ali kada isti dan dospjevaju na dva različita maila onda neće. Ovo je skripta, a meni baš ne ide toliko dobro php pa ne znam što je:
kod:
<?php
include('database.inc.php'); // Our database connectivity file
// Values you need set
$reminder_details = "";
$todays_date = date( "Ymd" );
$trigger_date = date("Ymd");
$result = mysql_query( "SELECT * FROM reminder_events WHERE reminder_date='$trigger_date' ORDER BY reminder_date ASC" );
$nr = mysql_num_rows( $result );
while( $row = mysql_fetch_array( $result ) )
{
$reminder_date = date("M j, Y", mktime (0,0,0,$month,$date,$year));
$reminder_details .= "Event: ".$row["reminder_name"]."\n";
$reminder_details .= "Date: ".$reminder_date."\n";
$reminder_details .= $row["reminder_desc"]."\n\n";
$email=mysql_result($result,$i,"email");
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send out Reminder mail
$mailheader = "From: Reminder System <$email>\nX-Mailer: Reminder\nContent-Type: text/plain";
mail("$email","Reminder","$reminder_details","$mailheader");
// Delete the sent reminders
mysql_query("DELETE FROM reminder_events WHERE reminder_date='$trigger_date'" );
}
?>
