Thread: Problem mit Kommentarzähler im Newssystem (fertig)

<?php
include("bbcode.php");
 
if (!include("confign.php")) die("Fehler! Config.php nicht gefunden!");
 
$ResultPointer = @mysql_query("SELECT News_ID, News_Titel, News_Text, News_URL, News_Autor, News_Erstellt FROM ".$DatabaseTable."_news ORDER BY News_Erstellt DESC LIMIT ".$MaximaleAnzahlNews, $DatabasePointer);
 
$AnzahlPointer = @mysql_query("SELECT COUNT(Kommentar_ID) AS Anzahl FROM _kommentare WHERE Kommentar_ID = ".$News_ID);
 
if(@mysql_num_rows($ResultPointer)>0)
{
      for($i=0; $i<@mysql_num_rows($ResultPointer); $i++)
      {
            $Result = mysql_fetch_object($ResultPointer);
            echo"<div algin=\"center\">",
            "<center>","<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"550\">",
                  "<tr>",
                  "<td bgcolor=\"#D1D1D1\"><b><img border=\"0\" src=\"iconpics/news.gif\" align=\"absbottom\" width=\"14\" height=\"19\"> ",
                  $Result->News_Titel,
                  "</b></td>",
                  "<td align=\"right\" bgcolor=\"#D1D1D1\"><b><i>",
                  substr($Result->News_Erstellt, 8, 2) . "." . substr($Result->News_Erstellt, 5, 2) . "." . substr($Result->News_Erstellt, 0, 4) . " " . substr($Result->News_Erstellt, 10, 6),
                  "</i></b></td>",
                  "</tr>",
                  "<tr>",
                  "<td colspan=\"2\" height=\"70\" valign=\"top\" bgcolor=\"#DADADA\">";
                  echo substr(nl2br(smilie(bbcode($Result->News_Text))), 0, 1000);
      if (strlen($Result->News_Text) > 1000) echo "...<a class=\"plain1\" href=\"newsfull.php?id=".$Result->News_ID."\">[mehr]</a>";
      else echo "";
                  echo "</td>",
                  "</tr>",
                  "<tr>",
                  "<td bgcolor=\"#D1D1D1\">";
            if(!Empty($Result->News_URL))
            {
                  echo"<a class=\"plain1\" href=\"",
                        $Result->News_URL,
                        "\">Link</a>";
            }
            else
            {
                  echo"&nbsp;";
            }
            echo"</td>",
                  "<td align=\"right\" bgcolor=\"#D1D1D1\"><i>von ",
                  $Result->News_Autor,
                  "</i></td>",
                  "</tr>",
                  "<tr>",
                  $AnzahlPointer->Anzahl,
                  "<td align=\"right\" colspan=\"2\" bgcolor=\"#D1D1D1\">",
                  "<a class=\"plain1\" href=\"comments.php?id=".$Result->News_ID."\">Kommentare</a>",
                  "</td>",
                  "</tr>",
                  "<tr>",
            "<td width=\"550\" colspan=\"2\" height=\"15\">",
            "<hr color=\"#D1D1D1\" size=\"1\">",
            "</td>",
            "</tr>",
            "<tr>",
            "<td width=\"550\" colspan=\"2\" height=\"19\">",
            "&nbsp;",
            "</td>",
                  "</tr>",
                  "</table>",
                  "</center>",
                  "</div>";
      }
}
else
{
      echo"Es wurden leider keine aktuellen News gefunden.";
}
 
?>

<?php
  $AnzahlPointer = @mysql_query("SELECT COUNT(Kommentar_ID) AS Anzahl FROM _kommentare WHERE Kommentar_ID = ".$News_ID);
  echo $AnzahlPointer->Anzahl;
?>

<?php
 
  $query ="SELECT `Kommentar_ID`, COUNT(`Kommentar_ID`) AS `Anzahl`
             FROM `_kommentare`
         GROUP BY `Kommentar_ID`";
  $result=mysql_query($query);
  $counts=array();
  while($kommentar=mysql_fetch_assoc($result)){
        $counts[$kommentar['Kommentar_ID']]=$kommentar['Anzahl']
        }
  //print_r($counts);
 
  /*
   * $counts sollte nun ein Array nach folgendem Aufbau sein:
   *
   * array(
   *       [Kommentar_ID] = 15,
   *       [Kommentar_ID] = 20,
   *       [Kommentar_ID] = 13
   *       );
   */
  
?>