if(isset($_GET["id"]))
{
mysql_query("SELECT * FROM news INNER JOIN user ON news.userid = user.id WHERE news.id = '".$_GET["id"]."' ")or die(mysql_error());
$newsdata = marray("SELECT * FROM news INNER JOIN user ON news.userid = user.id WHERE news.id = '".$_GET["id"]."' ");
?>
';
echo '';
echo ' ';
echo '
}else{
?>
';
echo '';
//echo '';
echo ' ';
echo ' ';
echo '
'; } ?>
} ?>
echo $newsdata["titel"] ?>
echo '
'.$newsdata["titel"]."
";
echo ''.$newsdata["text"]."
";
echo 'verfasst von '.$newsdata["user"].' am '.date("d.m.y H:i", $newsdata["time"])." Uhr
";
?>
News
$newssql = mysql_query("SELECT * FROM news INNER JOIN user ON news.userid = user.id WHERE news.status = 0 ORDER BY news.id DESC "); while($werte = mysql_fetch_array($newssql)) { echo '
'.$werte["titel"]."
";
echo 'verfasst von '.$werte["user"].' am '.date("d.m.y H:i", $werte["time"])." Uhr
";
echo ''; } ?>