Changeset 1218 for temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php

Timestamp:

2007/01/21 18:19:36 (19 years ago)

Author:

kakinaka

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php (modified) (1 diff)

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

@@ -14 +14 @@
 $objQuery = new SC_Query();
 
-$sql = 'SELECT topic_id, topic_title, topic_response, topic_time, uname FROM xoops_bb_topics as tpc left join xoops_users as usr on tpc.topic_response_uid = usr.uid ORDER BY topic_response, topic_id';
+$sql = 'SELECT topic_id, topic_title, topic_response, from_unixtime(topic_time) as topic_time, uname FROM xoops_bb_topics as tpc left join xoops_users as usr on tpc.topic_response_uid = usr.uid ORDER BY topic_response, topic_id';
 
 $arrList = $objQuery->getAll($sql);