Changeset 1220


Ignore:
Timestamp:
2007/01/21 18:20:27 (17 years ago)
Author:
kakinaka
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php

    r1219 r1220  
    1414$objQuery = new SC_Query(); 
    1515 
    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'; 
    1717 
    1818$arrList = $objQuery->getAll($sql); 
Note: See TracChangeset for help on using the changeset viewer.