統(tǒng)計(jì)記錄:
select count(*) as total from [!db.pre!]ecms_news union select count(*) as total from [!db.pre!]ecms_movie
查詢記錄:
select classid,id,titleurl,title,newstime from [!db.pre!]ecms_news union select classid,id,titleurl,title,newstime from [!db.pre!]ecms_movie order by newstime desc
-----------------------注釋:-------------------------------
以上調(diào)用的是(新聞模型:news、電影模型:movie)兩個(gè)模型的文章,兩個(gè)模型用"Union"連接調(diào)用
若指定欄目用:where classid in(46,47,51),
若調(diào)用推薦在其后追加:and isgood=1,
若指定調(diào)用條數(shù)在其后追加:limit 10
新聞熱點(diǎn)
疑難解答
圖片精選