$result = "SELECT count(*) as count FROM news, news_kommen WHERE news.n_id = news_kommen.nid";
$result = mysql_query($query);
$row = print_r($row);
also so gehtz auch nicht
cih poste mal die ganze page
<?
include("config.inc.php");
$timestamp = time();
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
$time_start = getmicrotime();
for ($i=0; $i < 10; $i++){
}
?>
<HTML>
<HEAD>
<? include("head.inc.php"); ?>
</HEAD>
<body leftmargin=0 rightmargin=0 topmargin=0 bottommargin=0>
<a name="top"></a><br>
<? include("head.menu.inc.php"); ?>
<br>
<?
echo "<table width=750 border=0 align=center cellpadding=1 cellspacing=1 bgcolor=000000>";
echo "<tr>";
echo "<td bgcolor=FFFFFF colspan=2><B>Die letzen 10 News:</b></td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$abfrage = "SELECT * FROM news ORDER BY n_id DESC LIMIT 10";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
nl2br($code);
echo "<table width=750 border=0 align=center cellpadding=1 cellspacing=1 bgcolor=000000>";
echo "<tr>";
echo "<td bgcolor=FFFFFF colspan=3>";
echo "<center><b>"; echo $row->titel;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td bgcolor=FFFFFF colspan=3>";
echo $row->blabla;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td bgcolor=FFFFFF width=30>";
echo "<font color=E46600> #$row->n_id </font>";
echo "</td>";
echo "<td bgcolor=FFFFFF width=720>";
echo "_<a href=comments.php?id=$row->n_id>comments [ ";
$query = "SELECT count(*) as count FROM news, news_kommen WHERE news.n_id = news_kommen.nid";
$result = mysql_query($query);
$row = mysql_fetch_object($result);
echo " ]</a> | by ";
echo "<a href=mailto:$row->mail>$row->autor</a> @ "; $time = date("d.m.Y - H:i",$row->zeit); echo $time," Uhr";
echo "</td>";
echo "</tr>";
echo "</table><br>";
}
?>
<? include("bottom.inc.php"); ?>
<br>
</body>
</HTML>