Discuz! 訊息: 數據庫查詢時出現錯誤
User: 黑加
時間: 2008-10-10 11:06pm
程序: /bbs/forumdisplay.php
SQL語法: SELECT t.*, p.rate, p.pid FROM [Table]threads t
LEFT JOIN [Table]posts p USING(tid, dateline)
WHERE t.fid='10' AND subject LIKE '%123%' AND t.displayorder IN (0, 1, 2, 3)
ORDER BY t.displayorder DESC, t.lastpost DESC
LIMIT 0, 30
錯誤: Column 'subject' in where clause is ambiguous
錯誤號碼: 1052
http://www.discuz.net/thread-1003836-1-1.html
http://www.discuz.net/thread-764630-1-1.html
這兩個有人話撞左-.-
佢都係出現呢個問題~~
唔知可以點改返好呢=.=
===============
頭像問題
唔知點解多左個邊
點可以縮細到岩岩好?
div.avatar { border: 1px solid #D6E0EF; background-image: url("../../images/default/catbg.gif"); padding: 3px; text-align: center; }
div.avatar img { background: #FFFFFF;}
[
本帖最後由 frankiemak 於 2008-10-11 00:17 編輯 ]
