A couple of additional smaller fixes.

[fa-stable.git] / admin / db / attachments_db.inc

diff --git a/admin/db/attachments_db.inc b/admin/db/attachments_db.inc
index 6934071f4756b46c30cbfad958f0ef497da8bcfc..6ce9960f2d1024321c49b50f12626ae7a1f9aa24 100644 (file)
--- a/admin/db/attachments_db.inc
+++ b/admin/db/attachments_db.inc
@@ -38,7 +38,7 @@ function update_attachment($selected_id, $filterType, $trans_no, $description,
                $sql .= "filename=".db_escape($filename).",
                unique_name=".db_escape($unique_name).",
                filesize=".db_escape($filesize).",
-               filetype=".db_escape($filetype);
+               filetype=".db_escape($filetype).",";
        }       
        $sql .= "tran_date='$date' WHERE id=".db_escape($selected_id);
        db_query($sql, "Attachment could not be updated");              
@@ -67,5 +67,16 @@ function get_attachment($id)
        return db_fetch($result);
 }
 
+function has_attachment($type, $id)
+{
+       $sql = "SELECT DISTINCT * FROM ".TB_PREF."attachments WHERE type_no=".db_escape($type)." AND trans_no=".db_escape($id);
+       $result = db_query($sql, "Could not retrieve attachments");
+       $myrow = db_fetch($result);
+       if ($myrow === false)
+               return 0;
+       else
+               return $myrow['id'];
+}
+
 
 ?>
\ No newline at end of file