Tad 教材網 - tad FAQ常見問題模組，無法修改排列順序

:::

XOOPS使用討論區

tad FAQ常見問題模組，無法修改排列順序

2013-07-13 09:06:44

windelf

請問老師，我在後台「faq列表」拖移問題時，可顯示修改後的順序，但在前台頁面仍是原先順序
其php除錯訊息如下：

0.000426 - SET NAMES 'utf8'

0.000157 - SET SQL_BIG_SELECTS = 1

0.000441 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC

0.000305 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'a85dc7a4180748dac80352ca8d178d4d'

0.000293 - SELECT * FROM users WHERE uid = '1'

0.000220 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()

0.000361 - SELECT COUNT(*) FROM protector_access WHERE ip='123.240.96.109' AND request_uri='/modules/tad_faq/admin/save_sort.php'

0.000272 - SELECT COUNT(*) FROM protector_access WHERE ip='123.240.96.109'

0.000258 - INSERT INTO protector_access SET ip='123.240.96.109',request_uri='/modules/tad_faq/admin/save_sort.php',expire=UNIX_TIMESTAMP()+'60'

0.000256 - SELECT * FROM modules WHERE dirname = 'tad_faq'

0.000244 - SELECT * FROM config WHERE (conf_modid = '15') ORDER BY conf_order ASC

0.000245 - update tad_faq_content set `sort`='1' where `fqsn`='29'

0.000278 - update tad_faq_content set `sort`='2' where `fqsn`='31'

0.000241 - update tad_faq_content set `sort`='3' where `fqsn`='30'

請問這該如何處理？謝謝！

2013-07-20 15:23:44

windelf

經查詢index檔後，發現若在第77行後面

$sql = "select * from ".$xoopsDB->prefix("tad_faq_content")." where fcsn='$fcsn' and enable='1'"

加上." order by sort";

前台頁面即可顯示新順序。敬請老師指導，謝謝。

2013-07-23 12:56:09

tad

嗯！這樣做應該是正確的！

:::

51人線上 (43人在瀏覽討論留言)

會員: 0

訪客: 51

更多…