統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]ecms_movie
查詢記錄: select * from [!db.pre!]ecms_movie order by id desc
注釋:[!db.pre!]ecms_movie 為數(shù)據(jù)表類型(movie是電影數(shù)據(jù)表)
desc - 降序排列 ASC - 升序排列
id desc 是按id降序排列 id ASC 是按id升序排列
舉一反三排序方式:id(id)、newstime (時(shí)間)、onclick(點(diǎn)擊或?yàn)g覽)、p統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]ecms_movie
查詢記錄: select * from [!db.pre!]ecms_movie order by id desc
注釋:[!db.pre!]ecms_movie 為數(shù)據(jù)表類型(movie是電影數(shù)據(jù)表)
desc - 降序排列 ASC - 升序排列
id desc 是按id降序排列 id ASC 是按id升序排列
舉一反三排序方式:id(id)、newstime (時(shí)間)、onclick(點(diǎn)擊或?yàn)g覽)、plnum (評(píng)論)、diggtop 、rand (隨機(jī))
如:增加當(dāng)前欄目(一般是錯(cuò)誤的,因自定義列表不能用當(dāng)前欄目這個(gè)參數(shù),這是只是一個(gè)引用以備其他地方應(yīng)用)
where classid='$GLOBALS[navclassid]'當(dāng)前欄目
統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]ecms_movie where classid='$GLOBALS[navclassid]'
查詢記錄: select * from [!db.pre!]ecms_movie where classid='$GLOBALS[navclassid]' order by id desc
---------------------------------------------------------------------------
自定義列表調(diào)用多個(gè)欄目,或指定欄目(sql中指定的欄目ID必須為終極欄目ID)
統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]ecms_movie where classid in (23,24,25)
查詢記錄: select * from [!db.pre!]ecms_movie where classid in (23,24,25) order by id desc
lnum (評(píng)論)、diggtop 、rand (隨機(jī))
如:增加當(dāng)前欄目(一般是錯(cuò)誤的,因自定義列表不能用當(dāng)前欄目這個(gè)參數(shù),這是只是一個(gè)引用以備其他地方應(yīng)用)
where classid='$GLOBALS[navclassid]'當(dāng)前欄目
統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]ecms_movie where classid='$GLOBALS[navclassid]'
查詢記錄: select * from [!db.pre!]ecms_movie where classid='$GLOBALS[navclassid]' order by id desc
---------------------------------------------------------------------------
自定義列表調(diào)用多個(gè)欄目,或指定欄目(sql中指定的欄目ID必須為終極欄目ID)
統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]ecms_movie where classid in (23,24,25)
查詢記錄: select * from [!db.pre!]ecms_movie where classid in (23,24,25) order by id desc
新聞熱點(diǎn)
疑難解答
圖片精選