<?php
@$mysql_res=mysql_connect( "localhost", "Catch22" );
//baue verbindung auf
if( ! $mysql_res ) {
   die( "Konnte verbindung zu mysql server nicht herstellen".mysql_error() );
  }
if( ! mysql_select_db( "Catch22" ) ) {
   die( "Konnte Datenbank nicht &ouml;ffnen" );
  }
//wähle datenbank
$news_res=mysql_query( "SELECT * FROM news", $mysql_res );
while( $row=mysql_fetch_array( $news_res, MYSQL_ASSOC ) ) {
   $news_array[]=$row;
  }
mysql_close( $mysql_res );
//schliesse verbindun
//die tabellen in denen die news stehen
print "<table border=1>";
print "<tr>";
print "<td>".$news_array[10]['title'];
print "</tr>";
print "<tr>";
print "<td>".$news_array[10]['content'];
print "</tr>";
print "</table>";
print "

&nbsp</P>";
print "<table border=1>";
print "<tr>";
print "<td>".$news_array[9]['title'];
print "</tr>";
print "<tr>";
print "<td>".$news_array[9]['content'];
print "</tr>";
print "</table>";
print "

&nbsp</P>";

//...

print "<table border=1>";
print "<tr>";
print "<td>".$news_array[2]['title'];
print "</tr>";
print "<tr>";
print "<td>".$news_array[2]['content'];
print "</tr>";
print "</table>";
print "

&nbsp</P>";
print "<table border=1>";
print "<tr>";
print "<td>".$news_array[1]['title'];
print "</tr>";
print "<tr>";
print "<td>".$news_array[1]['content'];
print "</tr>";
print "</table>";
print "

&nbsp</P>";
?>

include "dbconnect.php";
    if ($login)
	{
		$sql = "SELECT * FROM news ORDER BY news_id DESC";
	}
	else
	{
		$sql = "SELECT * FROM news WHERE intern_id = '0' ORDER BY news_id DESC";
	}
	$result = mysql_query($sql);
    $zeilen = mysql_num_rows($result);
    for ($i=($zeilen-5);$i<$zeilen;$i++)
    {
	$elemente = mysql_fetch_array($result);
	?>
	<table align="center" height="40" width="600" border="1" cellpadding="0" cellspacing="0" bgcolor="#000000">
		<tr>
		<td width="600" height="40" background="pics/balkenleft_v1.jpg">
		 <table align="center" height="40" width="596" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">
		  <tr>
    		<td width="500" height="40" align="left" background="pics/balkenleft_v1.jpg"><font color="#CCCCCC" size="+2"><? echo "$elemente[topic]"; ?></font></td>
			<td width="96" align="right" background="pics/balkenright_v1.jpg"><font color="#CCCCCC" size="-1"><? echo "$elemente[name]"; ?></font>

		    <font color="#CCCCCC" size="-2"><? echo "$elemente[date]"; ?></font></td>
		  </tr>
		 </table>
		</tr>
	</table>
	<table align="center" width="600" border="1" cellpadding="0" cellspacing="0" bgcolor="#ECD8B7">
		<tr>
			<td height="20" align="left" bgcolor="#000000"><font color="#C10000" size="-1"><? echo "$elemente[main]"; ?></font></td>
		</tr>
	</table>
<?
	$result2 = mysql_query("SELECT * FROM kommentare WHERE news_id = $elemente[news_id]");
	$count = mysql_num_rows($result2);
	?>
	<font color="#C10000" size="-1"><center>" target="_parent">Kommentare(<?echo "$count";?>)</center></font>
	

	

	<?
	}
	?>