<?php

      $db_host = "localhost";

      $db_user = "radio2009@1";

      $db_password = "xxxxxx";

      $db_name = "radio2009@1-12d";

  $connection = @mysql_connect($db_host, $db_user, $db_password) or die("Datenbankzugriff fehlgeschlagen: ".mysql_error());

  mysql_select_db($db_name, $connection);

  $chek = $_POST["loeschen"];

  $TickerQuery = "SELECT * FROM ticker ORDER BY ID DESC LIMIT 0, 10";

  $Ticker = mysql_query($TickerQuery, $connection) or die (mysql_error());

  $TickerID = mysql_result($Ticker, 0, "ID");

      echo "<form action='viewpage.php?page_id=1' method='POST'><br>

         Wunsch und Grußbox leeren?<br>

         <input type='hidden' name='loeschen' value='loeschen'>

        <input type='submit' value='Leeren'><br><hr></form>";

   

   if($chek == "loeschen"){

$Query = "DELETE FROM `ticker`";

mysql_query($Query, $connection);

   }

  for($i=0; $i < mysql_num_rows($Ticker); $i++){

    $Name1 = mysql_result($Ticker, $i, "Name");

    $Text = mysql_result($Ticker, $i, "Text");

    echo "<hr><br>Name:$Name1<br>

         Wunsch:$Text<br><hr>";

    if($i < mysql_num_rows($Ticker)-1)

      echo "&nbsp;<br>&rarr;&nbsp;";

  }

?>