query("SELECT *,DATE_FORMAT(ts,'%e.%c.%Y') AS date FROM news ORDER BY ts DESC,id DESC LIMIT 32"); while ($row = $res->fetch_assoc()) { extract($row); $titel = htmlspecialchars($title); $autor = htmlspecialchars($author); $stext = preg_replace('/\[\.\.\.\]/', '', $text); $stext = preg_replace('/

/', '

', $stext); echo "

$title

\n

$stext\n

$date $author\n"; } ?>