X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fattachments_db.inc;h=e18000fe3f8f2db9e6f61a70a4b416cdf3ca488c;hb=bd9a2064a4e308b2f056826a152e15f7795a2f20;hp=6ce9960f2d1024321c49b50f12626ae7a1f9aa24;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git diff --git a/admin/db/attachments_db.inc b/admin/db/attachments_db.inc index 6ce9960f..e18000fe 100644 --- a/admin/db/attachments_db.inc +++ b/admin/db/attachments_db.inc @@ -78,5 +78,11 @@ function has_attachment($type, $id) return $myrow['id']; } +function get_sql_for_attached_documents($type) +{ + return "SELECT trans_no, description, filename, filesize, filetype, tran_date, id, type_no FROM ".TB_PREF."attachments WHERE type_no=".db_escape($type) + ." ORDER BY trans_no DESC"; +} + ?> \ No newline at end of file