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

Timestamp:

2007/01/21 18:16:15 (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 FROM xoops_bb_topics ORDER BY topic_response, topic_id';
+$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';
 
 $arrList = $objQuery->getAll($sql);