这个语句报什么错啊
我估计
$query = "SELECT zt.userid,count(total_re) as total_re, users.blog_name FROM zt inner jion users on zt.userid=users.userid where blog_name <> 'NULL' group by zt.userid DESC";
这样看看,还有就是total_re,blog_name 是哪个表的啊
我估计
$query = "SELECT zt.userid,count(total_re) as total_re, users.blog_name FROM zt inner jion users on zt.userid=users.userid where blog_name <> 'NULL' group by zt.userid DESC";
这样看看,还有就是total_re,blog_name 是哪个表的啊
blog_name 归属不清楚
$query = "SELECT zt.userid,count(total_re) as total_re, users.blog_name FROM zt inner jion users on zt.userid=users.userid where users.blog_name <> 'NULL' group by zt.userid order by zt.userid DESC";
$result = mysql_query($query,$db);
$row = mysql_fetch_array($result);?>
<div align="center"><span class="style6">经典BLOG推荐</span></div>
<div align="center"><?php do { ?>
<li><a href="main2.php?uid= <? echo $row['zt.userid']; ?>"><?php echo ChgTitle($row['users.blog_name'],26); ?></a></li><?php } while ($row = mysql_fetch_assoc($result)); ?>