Changeset 4669 for temp/trunk

Timestamp:

2006/09/13 10:51:47 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

temp/trunk/html/admin/home.php

@@ -104 +104 @@
     // postgresql ¤È mysql ¤È¤ÇSQL¤ò¤ï¤±¤ë
     if (DB_TYPE == "pgsql") {
-        $sql = "SELECT COUNT (*) FROM dtb_review 
+        $sql = "SELECT COUNT(*) FROM dtb_review 
                  WHERE del_flg=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
                  AND to_char(create_date,'YYYY/MM/DD') != to_char(now(),'YYYY/MM/DD')";
     }else if (DB_TYPE == "mysql") {
-        $sql = "SELECT COUNT (*) FROM dtb_review 
+        $sql = "SELECT COUNT(*) FROM dtb_review 
                  WHERE del_flg = 0 AND cast(substring(create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day)
                  AND cast(substring(create_date,1, 10) as date) != cast(substring(now(),1, 10) as date)";
@@ -117 +117 @@
 
 function lfGetReviewNonDisp($conn){
-    $sql = "SELECT COUNT (*) FROM dtb_review WHERE del_flg=0 AND status=2";
+    $sql = "SELECT COUNT(*) FROM dtb_review WHERE del_flg=0 AND status=2";
     $return = $conn->getOne($sql);
     return $return;