Changeset 1220
- Timestamp:
- 2007/01/21 18:20:27 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php
r1219 r1220 14 14 $objQuery = new SC_Query(); 15 15 16 $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 DESC, topic_id';16 $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 DESC'; 17 17 18 18 $arrList = $objQuery->getAll($sql);
Note: See TracChangeset
for help on using the changeset viewer.