<!--{loop:video:$video nid=$c1['nid']|showsub=1|limit=10|order=lastdate DESC,postdate DESC,v.vid DESC|dateformat=1}-->对应数据库 表中的结构CREATE TABLE `pv_video` (
`vid` mediumint(8) unsigned NOT NULL auto_increment,
`cid` smallint(6) unsigned NOT NULL default '0',
`nid` smallint(6) unsigned NOT NULL default '0',
`author` char(15) NOT NULL default '',
`authorid` mediumint(8) unsigned NOT NULL default '0',
`postdate` int(10) unsigned NOT NULL default '0',
`lastdate` int(10) unsigned NOT NULL default '0',
`subject` char(100) NOT NULL default '',
`picfolder` char(50) NOT NULL default '',
`pic` char(100) NOT NULL default '',
`playactor` char(30) NOT NULL default '',
`director` char(30) NOT NULL default '',
`tag` char(100) NOT NULL default '',
`year` char(10) NOT NULL default '',
`content` mediumtext NOT NULL,
`best` tinyint(1) NOT NULL default '0',
`serialise` smallint(5) unsigned NOT NULL default '0',
`memo` text NOT NULL,
`yz` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`vid`),
KEY `bid` (`cid`),
KEY `nid` (`nid`)
)
只解释 PHP 语句 如何按nid排序
`vid` mediumint(8) unsigned NOT NULL auto_increment,
`cid` smallint(6) unsigned NOT NULL default '0',
`nid` smallint(6) unsigned NOT NULL default '0',
`author` char(15) NOT NULL default '',
`authorid` mediumint(8) unsigned NOT NULL default '0',
`postdate` int(10) unsigned NOT NULL default '0',
`lastdate` int(10) unsigned NOT NULL default '0',
`subject` char(100) NOT NULL default '',
`picfolder` char(50) NOT NULL default '',
`pic` char(100) NOT NULL default '',
`playactor` char(30) NOT NULL default '',
`director` char(30) NOT NULL default '',
`tag` char(100) NOT NULL default '',
`year` char(10) NOT NULL default '',
`content` mediumtext NOT NULL,
`best` tinyint(1) NOT NULL default '0',
`serialise` smallint(5) unsigned NOT NULL default '0',
`memo` text NOT NULL,
`yz` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`vid`),
KEY `bid` (`cid`),
KEY `nid` (`nid`)
)
只解释 PHP 语句 如何按nid排序
<!--{loop:video:$video nid=$c1['nid']|showsub=1|limit=10|order=lastdate DESC,postdate DESC,v.vid DESC|dateformat=1}-->
<div class="block">
<ul>
<!--{loop:video:$video nid=$c1['nid']|showsub=1|limit=10|order=lastdate DESC,postdate DESC,v.vid DESC|dateformat=1}-->
<li>
<span class="fr">$video[lastdate]</span>
<span class="sj"><a href="read.php?vid=$video[vid]" title="$video[subject]">$video[subject]</a></span>
</li>
<!--{/loop:video}-->
</ul>
</div>
<!--{loop:video:$video cid=$c1['cid']|showsub=1|limit=10|order=lastdate DESC,postdate DESC,v.vid DESC|dateformat=1}-->
这对应 select 语句的 where 部分order=lastdate DESC,postdate DESC,v.vid DESC
才是排序
我想让这条代码 只排电影 按照时间最新排序 但这条代码 执行的结果显示其中包括电影、电视剧、动漫、综艺
不是只排电影 数据库中nid应该是代指四个栏目
KEY `bid` (`cid`),
KEY `nid` (`nid`)
vid、cid、nid 构成联合主键,撇开自增的 vid
cid 和 nid 应该表示大分类和小分类
单独对小分类排序,显然是不妥的
因为在不同的大分类下,小分类编号是可以重复的同样,过滤条件 nid=$c1['nid'] 也是不妥的