e/pl/more/index.php 中的 $sql=$empire->query("select username,saytime,saytext from {$dbtbpre}enewspl where id='$id' and classid='$classid' and checked=0 order by plid desc limit ".$num); 替换成 $sql=$empire->query("select a.username,a.saytime,a.saytext,b.userpic from {$dbtbpre}enewspl as a left join phome_enewsmemberadd as b on a.userid = b.userid where a.id='$id' and a.classid='$classid' and a.checked=0 order by plid desc limit ".$num);
$r[userpic] 是头像地址
因为双表查询,影响效率,权衡后使用
|