|
$res = mysql_query("SELECT * FROM news WHERE ADDDATE(added, INTERVAL 45 DAY) > NOW() ORDER BY added DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) > 0)
{
$first = TRUE;
begin_table(TRUE);
while($array = mysql_fetch_array($res))
{
$user_id=$array['userid'];
$res_username=mysql_query("SELECT username FROM users WHERE id=$user_id") or sqlerr(__FILE__, __LINE__);
$username=mysql_fetch_array($res_username);
$news_date=date("Y-m-d",strtotime($array['added']));
$news_year=substr($news_date,0,4);
$news_month=substr($news_date,5,2);
$news_day=substr($news_date,8,2);
$news_date=$news_day . "." . $news_month . "." . $news_year;
$news_day=date("l",mktime(0,0,0,$news_month,$news_day,$news_year));
if ($news_day == "Monday")
$news_day="Montag";
if ($news_day == "Tuesday")
$news_day="Dienstag";
if ($news_day == "Wednesday")
$news_day="Mittwoch";
if ($news_day == "Thursday")
$news_day="Donnerstag";
if ($news_day == "Friday")
$news_day="Freitag";
if ($news_day == "Saturday")
$news_day="Samstag";
if ($news_day == "Sunday")
$news_day="Sonntag";
echo " |