以下是我的php代碼：$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads ORDER BY dateline DESC LIMIT 10"
1 回答
牧羊人nacy
TA貢獻1862條經驗 獲得超7個贊
如果空值是:NULL
則：
$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads WHERE tags IS NOT NULL ORDER BY dateline DESC LIMIT 10"
如果空值是:''
$sql = "SELECT author,tags,subject,tid,authorid,dateline,fid FROM threads WHERE tags !='' ORDER BY dateline DESC LIMIT 10"
- 1 回答
- 0 關注
- 120 瀏覽
添加回答
舉報
0/150
提交
取消