" width="100%" border="0" cellspacing="0" cellpadding="0" width="100%">

Neues in den letzten 7 Tagen

'$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Artikel
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[name].""; } echo "

"; } //Bücher $result = mysql_query("select * from buecher where datum > '$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Bücher
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[titel].""; } echo "

"; } //Downloadarchive $result = mysql_query("select * from downloadarchive where datum > '$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Download Archive
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[name].""; } echo "

"; } //FAQ $result = mysql_query("select * from faq where datum > '$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
FAQ
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[frage].""; } echo "

"; } //Glossar $result = mysql_query("select * from glossar where datum > '$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Glossar

"; } //Howtos $result = mysql_query("select * from howtos where datum > '$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Howtos
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[name].""; } echo "

"; } //Links $result = mysql_query("select * from links where datum > '$olddate' and validate='true'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Links
    "; while($row = mysql_fetch_array($result)){ $result2 = mysql_query("select * from kategorien where id='$row[kategorie]'"); $row2 = mysql_fetch_array($result2); $result3 = mysql_query("select * from kategorien where id='$row2[kat]'"); $row3 = mysql_fetch_array($result3); if ($row[url]){ echo "
  • $row3[name] - $row2[name]: $row[titel]"; } else { echo "
  • $row3[name] - $row2[name]: $row[titel]"; } } echo "

"; } //News $result = mysql_query("select * from news where t_stamp > '$t_stamp' and validate='true'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
News
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[titel].""; } echo "

"; } //Online Doku $result = mysql_query("select * from onlinedoku where datum > '$olddate'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Online Dokumentationen
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[name].""; } echo "

"; } //Software $result = mysql_query("select * from software where datum > '$olddate' and validate='true'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Software
    "; while($row = mysql_fetch_array($result)){ $result2 = mysql_query("select * from softwarekategorien where id='$row[kategorie]'"); $row2 = mysql_fetch_array($result2); $result3 = mysql_query("select * from softwarekategorien where id='$row2[kat]'"); $row3 = mysql_fetch_array($result3); echo "
  • $row3[name] - $row2[name]: $row[titel]"; } echo "

"; } //Tips $result = mysql_query("select * from tips where datum > '$olddate' and validate='true'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Tips
    "; while($row = mysql_fetch_array($result)){ $result2 = mysql_query("select * from tipskategorien where id='$row[kategorie]'"); $row2 = mysql_fetch_array($result2); $result3 = mysql_query("select * from tipskategorien where id='$row2[kat]'"); $row3 = mysql_fetch_array($result3); echo "
  • $row3[name] - $row2[name]: $row[titel]"; } echo "

"; } //Witze $result = mysql_query("select * from witze where t_stamp > '$t_stamp'"); $num = mysql_num_rows($result); if ($num){ echo ""; echo ""; echo "
Witze
    "; while($row = mysql_fetch_array($result)){ echo "
  • ".$row[titel].""; } echo "

"; } ?>