Changeset 1053 for temp

Timestamp:

2007/01/09 18:09:08 (19 years ago)

Author:

kaki

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/test/kakinaka/topic_list.php (modified) (2 diffs)

temp/test-xoops.ec-cube.net/html/test/kakinaka/topic_list.php

@@ -5 +5 @@
 global $arrResponse;
 
-$sql = 'SELECT topic_id, topic_title, topic_response FROM ' . $xoopsDB->prefix('bb_topics') . ' ORDER BY topic_response, topic_id';
-
-echo date("Y/m/d H:i:s", 1157712086);
-
+$sql = 'SELECT topic_id, topic_title, topic_response, topic_time FROM ' . $xoopsDB->prefix('bb_topics') . ' ORDER BY topic_response, topic_id';
 
 if ( !$result = $xoopsDB->query($sql) ) {
@@ -15 +12 @@
 }
 
-print_r($xoopsDB);
-
 while ( $myrow = $xoopsDB->fetchArray($result) ) {
-    
-    //$post_sql = 'SELECT max(post_time) FROM xoops_bb_posts group by topic_id WHERE topic_id = ' . $myrow[];
-
     foreach($myrow as $key => $val){
         //$val = mb_convert_encoding($val, "euc-jp");
-        if($key == "topic_response"){
-            print("¡Ú" . $arrResponse[$val] . "¡Û");
-        }else{
-            print($val . "\t");
+        
+        switch ($key) {
+            case "topic_response":
+                print("¡Ú" . $arrResponse[$val] . "¡Û");
+                break;
+            case "topic_time":
+                print(date("Y/m/d H:i:s"), $val);
+                break;
+            default:
+                print($val . "\t");
+                break;
+            
         }
     }