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

Timestamp:

2007/01/09 17:56:01 (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

@@ -7 +7 @@
 $sql = 'SELECT topic_id, topic_title, topic_response FROM ' . $xoopsDB->prefix('bb_topics') . ' ORDER BY topic_response, topic_id';
 
-
-echo date("Y/m/d l H:i:s", 1157712086);
+echo date("Y/m/d H:i:s", 1157712086);
 
 
@@ -16 +15 @@
 }
 
+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[];
+    if ( !$post_result = $xoopsDB->query($post_sql) ) {
+        redirect_header(XOOPS_URL.'/',1,_MD_ERROROCCURED);
+        exit();
+    }
+
 
     foreach($myrow as $key => $val){