Question

php多表问题，输出其他正常但lid=<?php echo $row['mid'];?>">没有值

$result=mysql_query("SELECT m.shoptype,m.shopname , m.present ,m.mid ,r.mid ,r.rid ,r.LastWeek_Hits,ff.mid,ff.LieBiaoYeKaiShi,ff.LieBiaoYeFuFei from money AS ff right JOIN tb_ranking AS r ON ff.rid=r.rid right JOIN tb_members AS m ON r.mid=m.mid where m.shoptype='$val' AND m.shopname!='' ORDER BY ff.LieBiaoYeFuFei DESC,r.LastWeek_Hits DESC,m.mid limit $firstcount,$displaypg ");
if($result==false){
echo "部分信息暂时没有!";
}else{
while($row=mysql_fetch_array($result)){
?>
<div class="LeftSidebar">
<div class="shopname"> 店名 ：
<a style="font-size:16px; color:#000;
" href="shop.php?lid=<?php echo $row['mid'];?>">
<?php
if($row['LieBiaoYeFuFei']=='1'){
echo "<span style=\"font-weight:bold;\">".$row['shopname']."</span>";}
else {echo $row['shopname'];}
?></a>
</div>
<div class="present" style="font-size:14px;
"> 介绍 ：</div>
<div class="presentContent">
<?php
echo substr($row['present'],0,272);
?></div>
</div>
<?php
}
}
mysql_free_result($result);

Answer 1

其他值正常,查看数据库是否mid有值