php MYSQL如何为查询数据的结果编上序号 while判断第几条

<?
$tsql=$empire->query("select (@i:=@i+1) i,tagid from {$dbtbpre}enewstagsdata , (SELECT @i:=0) as i where id='$navinfor[id]' and classid='$navinfor[classid]' ");
while($tr=$empire->fetch($tsql)){
    $tt=$empire->fetch1("select  * from {$dbtbpre}enewstags where tagid=".$tr['tagid']."  limit 1");
    $current='';
    if($tr['i']==1){
    $current=' current';
    }
    echo '<ul class="meishi-pic tab-item'. $current.'">';
    $ttn=$empire->query("select * from {$dbtbpre}ecms_news where title like '%".$tt['tagname']."%'  order by onclick desc limit 6");
    while($trn=$empire->fetch($ttn)){
    echo  '<li>
        <a href="'.$trn['titleurl'].'" target="_blank">
          <img class="lazy" data-original="'.$trn['titlepic'].'" alt="">
          <span class="info-m">'.$trn['title'].'</span>
          <b class="bg"></b>
        </a>
      </li>';
}
echo ' </ul>';
}
?>

来源：https://www.imhu.cn/days/801

赏 支付宝打赏 微信打赏

如果文章或资源对您有帮助，欢迎打赏作者。一路走来，感谢有您！