- implode: documentation ( source)
<?php
//select all attachments
$attachments_select="('".implode("', '", $VAR['add_attachments'])."')";
$q = "SELECT * FROM ".PRFX."TABLE_WORK_ORDER_ATTACHMENTS WHERE `WO_ID`=".$db->qstr($wo_id)." AND `ATTACHMENT_ID` IN $attachments_select ORDER BY `ATTACHMENT_ID` DESC";
if(!$rs = $db->execute($q)) {
force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database');
exit;
}
$attachments = $rs->GetArray();
foreach($attachments as $a){
$file=$a['WO_ID']."_".$a['ATTACHMENT_NUMBER']."_".$a['ATTACHMENT_FILE'];
$email->addAttachment(FILE_ROOT.'upload/message_store/'.$file, $file);
}