'; while ($row1 = pg_fetch_assoc($stmt1)) { $read_status = $row1['read_status']; if ($read_status == 'Y') $read_status = ''; $reminding_invited_company = ''; $email_send_earlier = $row1['email_send_earlier']; if ($email_send_earlier == '') $email_send_earlier = $row1['log_timestamp']; if ($row1['email_reason'] == 'Invited company to join my trusted doctor network' && $row1['login_email'] == '' && ((strtotime($email_send_earlier) + 3 * 24 * 60 * 60) < strtotime('now'))) $reminding_invited_company = 'Invite again(' . ($row1["attempt"] + 1) . ')'; else if ($row1['email_reason'] == 'Invited company to join my trusted doctor network' && $row1['login_email'] != '') $reminding_invited_company = ''; $track_it = 'Track it'; echo ' '; } echo '

Sno	Receiver	Receiver Name	Sending Reason	Email Subject	Sending Time	Read Time	Read status	Action
' . $row1['sno'] . '	' . $row1['email_send_to'] . '	' . $row1['to_name'] . '	' . $row1['email_reason'] . '	' . $row1['email_subject'] . '	' . (($row1['log_timestamp'] != '') ? date('M d Y h:i a', strtotime($row1['log_timestamp'])) : "") . '	' . (($row1['read_timestamp'] != '') ? date('M d Y h:i a', strtotime($row1['read_timestamp'])) : "") . '	' . $read_status . '	' . $reminding_invited_company . $track_it . '