Changeset 5202 for temp/trunk/data/lib

Timestamp:

2006/09/20 11:18:00 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/lib/slib.php (modified) (1 diff)

temp/trunk/data/lib/slib.php

@@ -2129 +2129 @@
     
     //³Æ¥«¥Æ¥´¥êÆâ¤Î¾¦ÉÊ¿ô¤ò¿ô¤¨¤Æ³ÊǼ
-    $sql = " INSERT INTO dtb_category_count(category_id, product_count) ";
-    $sql .= " SELECT T1.category_id, count(T2.category_id) FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 ";
+    $sql = " INSERT INTO dtb_category_count(category_id, product_count, now()) ";
+    $sql .= " SELECT T1.category_id, count(T2.category_id), now() FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 ";
     $sql .= " ON T1.category_id = T2.category_id  ";
     $sql .= " WHERE T2.del_flg = 0 AND T2.status = 1 ";