Changeset 4608 for temp/trunk/html/admin/mail/template.php

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/mail/template.php (modified) (2 diffs)

temp/trunk/html/admin/mail/template.php

@@ -35 +35 @@
     
     // ÅÐÏ¿ºï½ü
-    $sql = "UPDATE dtb_mailmaga_template SET delete = 1 WHERE template_id = ?";
+    $sql = "UPDATE dtb_mailmaga_template SET del_flg = 1 WHERE template_id = ?";
     $conn->query($sql, array($_GET['id']));
     sfReload();
@@ -41 +41 @@
 
 
-$sql = "SELECT *, to_char(create_date, 'YYYY/MM/DD HH24:MI') as disp_date FROM dtb_mailmaga_template WHERE delete = 0 ORDER BY create_date DESC";
+$sql = "SELECT *, to_char(create_date, 'YYYY/MM/DD HH24:MI') as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC";
 $objPage->list_data = $list_data = $conn->getAll($sql);
 $objPage->arrMagazineType = $arrMagazineTypeAll;