"; msg_box("Account not found", "Your Account was not found in the database.", "black"); echo ""; exit; } if ($ckpasswd==$epasswd){ /* Query Database */ $num=1; $result=mysql_query(" SELECT email, subject, comment, UNIX_TIMESTAMP(date_field),id,recurring,recur_num,recur_val,adv_notice,notify_num,notify_val FROM notify WHERE email='$email' "); echo "

"; while ($row=mysql_fetch_array($result)){ $email=$row['email']; $subject=$row['subject']; $comment=$row['comment']; /* Get date field to friendly format */ $date_field=$row['UNIX_TIMESTAMP(date_field)']; $neat_date=date("D M d, Y h:i:s A",$date_field); $id=$row['id']; $recurring=$row['recurring']; $recur_num=$row['recur_num']; $recur_val=$row['recur_val']; $adv_notice=$row['adv_notice']; $notify_num=$row['notify_num']; $notify_val=$row['notify_val']; $r1=$recurring.", ".$recur_num." ".$recur_val; $n1=$adv_notice.", ".$notify_num." ".$notify_val; if ($recurring=="") {$r1="no";} if ($adv_notice=="") {$n1="no";} echo " "; $num=$num+1; } if ($num==1) { echo " "; } echo "

Pending E*Reminders for: $email
Delete	Date of next message	Advance Notice	Recurring	Event	Message
	$neat_date $dbtimezone	$n1	$r1	$subject	$comment
You have no pending E*Reminders!
					Help/About Account Options Home

"; } else { echo ""; msg_box("Incorrect Password", "Please enter correct password and try again.", "black"); } ?>