Thanks again guys for your help here. I’ve tried multiple things again, using the suggestions and now think I must be missing something else. I have tried so many different things and am getting emails but no attachment - any help / suggestion would be much much appreciated!
I’ve attached 3 images - one of the MySql database (I assume the image field should be a blob even though we’re doing file name), one of Scriptcase Edit Fields (to show you how they’re configured), and one of the actual Field (in case there is anything I didn’t set correctly in it). The “OnAfterInsert” code looks like this:
[rptid] = {Rcrdid};
$mail_message = NULL;
// Get email settings for sending mail
sc_lookup(em, “SELECT smtp_server, smtp_user, mail_from, smtp_pwd, mail_to_alert, mail_to_board FROM tbl_mail WHERE type = ‘main’”);
[server] = {em[0][0]};
[user] = {em[0][1]};
[from] = {em[0][2]};
[pwd] = {em[0][3]};
[toalert] = {em[0][4]};
[board] = {em[0][5]};
// Get details of new submission
$check_sql = “SELECT added, name, phone, email, address, whenobserved, description, discussed, image FROM reports WHERE rcrdid = [rptid]”;
sc_lookup(rp, $check_sql);
[rp_added] = {rp[0][0]};
[rp_name] = {rp[0][1]};
[rp_phone] = {rp[0][2]};
[rp_email] = {rp[0][3]};
[rp_address] = {rp[0][4]};
[rp_observed] = {rp[0][5]};
[rp_descrip] = {rp[0][6]};
[rp_discuss] = {rp[0][7]};
[rp_image] = {rp[0][8]};
// ** Send email notification
// Email parameters
$mail_smtp_server = “[server]”; // SMTP server name or IP address
$mail_smtp_user = “[user]”; // SMTP user name
$mail_smtp_pass = “[pwd]”; // SMTP password
$mail_from = “[from]”; // From email
$mail_to = “[toalert]”; // To email
$mail_subject = "Attention - New Submission ID: " . [rptid]; // Message subject
$mail_message = $mail_message.‘The following information was just submitted: <br><br>’; // Message body
$mail_message = $mail_message.'Reported date: ’ . date(“l, jS \of F Y”,strtotime([rp_added])) . ‘<br>’;
$mail_message = $mail_message."Reporting: " . [rp_name] . “<br>” ;
$mail_message = $mail_message."Number: " . [rp_phone] . “<br>” ;
$mail_message = $mail_message."Address: " . [rp_email] . “<br>” ;
$mail_message = $mail_message."Residence: " . [rp_address] . “<br>” ;
$mail_message = $mail_message."Observed: " . [rp_observed] . “<br>” ;
$mail_message = $mail_message."Description: " . [rp_descrip] . “<br><br>” ;
$mail_message = $mail_message."Discussions (if app): " . [rp_discuss] . “<br><br>” ;
$mail_message = $mail_message.“Thank you,” . “<br><br>”;
$mail_message = $mail_message."Alert Team. ";
$mail_format = ‘H’; // Message format: (T)ext or (H)tml
if (empty([rp_image]))
{
$mail_attachments = ’ ';
}
else
{
$mail_attachments = ‘/home/user/public_html/reports/_lib/file/img/’.[rp_image];
}
// Send email";
sc_mail_send($mail_smtp_server,
$mail_smtp_user,
$mail_smtp_pass,
$mail_from,
$mail_to,
$mail_subject,
$mail_message,
$mail_format,
‘’,
‘’,
‘’,
‘’,
$mail_attachments);
