<?php
$sql=$empire->query("select * from {$dbtbpre}ecms_jf where jinyi !='' and fanyi !='' order by onclick limit 40");
while($r=$empire->fetch($sql)){
?>
<li><a href="<?=$r[titleurl]?>"><span>[近反义词]</span><?=$r[title]?></a></li>
<?}?>
Select CodeCopy
解释:
where jinyi !=” and fanyi !=”
jinyi不等于空 并且 fanyi不等于空
== 等于
!= 不等于