Changeset 4867 for temp/trunk

Timestamp:

2006/09/17 16:49:46 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/conf.php (modified) (1 diff)
• html/frontparts/bloc/news.php (modified) (1 diff)

temp/trunk/data/conf/conf.php

@@ -816 +816 @@
     FROM
         dtb_products AS T1 RIGHT JOIN (SELECT product_id AS product_id_sub, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY product_id) AS T2 ON T1.product_id = T2.product_id_sub
-    ) chvw_products_allclass ',
+    ) ',
 
     "vw_products_allclass_detail" => '

temp/trunk/html/frontparts/bloc/news.php

@@ -19 +19 @@
 function lfGetNews(){
     $conn = new SC_DBConn();
-    $sql = "SELECT *, to_char(news_date, 'YYYY/MM/DD') as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
+    $sql = "SELECT *, cast(substring(news_date,1,10) as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
     $list_data = $conn->getAll($sql);
     return $list_data;