帝国cms用php代替灵动标签写法/条件判断其他字段是否为空

<?ref="https://xwenw.com/tag/php" target="_blank">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>
<?}?>

解释：

where jinyi !=” and fanyi !=”

jinyi不等于空 并且  fanyi不等于空

== 等于

!= 不等于

附怎么输出所属的栏目名跟栏目地址呢？以下实例：

<?php  
$class_arr = [];  
$class_sql = $empire->query("select classid, classname, classpath from {$dbtbpre}enewsclass");  
while ($class_row = $empire->fetch($class_sql)) {  
    $class_arr[$class_row['classid']] = $class_row;  
}  

$sql = $empire->query("select * from {$dbtbpre}ecms_soft order by newstime DESC limit 8");  
while ($r = $empire->fetch($sql)) {  
?> 

<span class="four">
<a href="/<?= $class_arr[$r['classid']]['classpath'] ?>/"><?= $class_arr[$r['classid']]['classname'] ?></a>
</span>

<?}?>