Changeset 354 for branches/dev/html/products/detail.php

Timestamp:

2007/02/22 18:53:06 (19 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/html/products/detail.php (modified) (1 diff)

branches/dev/html/products/detail.php

@@ -421 +421 @@
     $col = "create_date, reviewer_url, reviewer_name, recommend_level, title, comment";
     $from = "dtb_review";
-    $where = "del_flg = 0 AND status = 1 AND product_id = ? ";
+    $where = "del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT " . REVIEW_REGIST_MAX;
     $arrval[] = $id;
     $arrReview = $objQuery->select($col, $from, $where, $arrval);