文章标签云PHP的MySQL

Question

我有我的文章标签，我想为它的标签云，但我不能弄清楚如何做到这一点

任何帮助将是不错

$result = mysql_query("SELECT *, COUNT(login_news.tag) FROM login_tags 
         LEFT JOIN login_news ON login_tags.tag_id = login_news.tag GROUP BY tag_id 
          "); 


    while($row = mysql_fetch_array($result)){ 



     echo $row['name']; 
     echo "<br>"; 
     echo $row['COUNT(login_news.tag)']; 
     echo "<br>"; 

     } 

这是像我猜测的

Answer 1

试试这个，加入AS添加MySQL别名来算（login_news.tag），并把它称为在PHP作为$结果[“aliasname的”]

$result = mysql_query("SELECT *, COUNT(login_news.tag) AS tag_count FROM login_tags 
          LEFT JOIN login_news ON login_tags.tag_id = login_news.tag GROUP BY tag_id 
           "); 


     while($row = mysql_fetch_array($result)){ 
      echo $row['name']; 
      echo "<br>"; 
      echo $row['tag_count']; 
      echo "<br>"; 

     } 

Answer 2

这是我做到了-_-

$result = mysql_query("SELECT tag_id, tag_name, COUNT(login_news.tag) AS tag_count FROM login_tags 
    INNER JOIN login_news ON login_tags.tag_id = login_news.tag GROUP BY tag_name 
            "); 


      while($row = mysql_fetch_array($result)){ 

      if($row['tag_count'] > 5){ 

      $fontsize = "11"; 

      } 

      if ($row['tag_count'] > 15){ 

      $fontsize = "13"; 

      } 

      if ($row['tag_count'] > 30){ 

      $fontsize = "15"; 

      } 

      ?> 


      <li style="font-size:<?php echo $fontsize?>!important;"><a href="/index.html?tag=<? echo $row['tag_id']; ?>" title="<? echo $row['tag_count']; ?> სიახლე"><? echo $row['tag_name']; ?></a> </li> 


     <? 

      } 



    ?>