$date = date(´d.m.y´);
$sql = "insert into forum (forum, theard, von, date, posts, text) values (´$forum´,´$theard´,´$nick´,´$date´,´$post´,´$msg´)";
mysql_query($sql);
$sql = "select * from forums";
$abfarge = mysql_query($sql);
while ($row = mysql_fetch_array($abfrage))
  {
  if ($row[theards] == ´$forum|$theard´)
    {
    $altposts = $row[posts];
    $posts = $altposts++;
    $state = $row[open]
    }
  }

$sql1 = update ´forums´ SET ´posts´ = ´$posts´ WHERE CONVERT (´forums´.´name´ USING utf8) = ´$forum´ AND CONVERT (´forums´.´theards´ using utf8) = ´$forum|$theard´ AND CONVERT (´forums´.´open´ using utf8) = ´$state´ AND ´forums´.´posts´ = $altposts LIMIT 1;";
mysql_query($sql1);