Changeset 5203 for temp/trunk/data/lib/slib.php
- Timestamp:
- 2006/09/20 11:18:17 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/data/lib/slib.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/data/lib/slib.php
r5202 r5203 2129 2129 2130 2130 //³Æ¥«¥Æ¥´¥êÆâ¤Î¾¦ÉÊ¿ô¤ò¿ô¤¨¤Æ³ÊǼ 2131 $sql = " INSERT INTO dtb_category_count(category_id, product_count, now()) ";2131 $sql = " INSERT INTO dtb_category_count(category_id, product_count, create_date) "; 2132 2132 $sql .= " SELECT T1.category_id, count(T2.category_id), now() FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 "; 2133 2133 $sql .= " ON T1.category_id = T2.category_id ";
Note: See TracChangeset
for help on using the changeset viewer.
