<?
//***** Datenbankverbindung herstellen*********
$verbindung = mysql_connect("localhost","root", '');


//***** Datenbank wählen *******************
mysql_select_db("ticketsystem",$verbindung);


//***** SQL Abfrage in die Variable $sql speichern ******
$sql = "SELECT * FROM ticket";

//****** SQL Abfrage starten ************
$result = mysql_query($sql);

//****** Datensätze zählen ************
$num_ticket = mysql_num_rows($result);
unset ($sql);

$sql = "SELECT t.ticket_name, t.ticket_datum, t.ticket_id, and s.supporter_name FROM ticket as t join supporter as s Where t.supporter_id=s.supporter_id";
 
//****** Tabelle definieren & Kopfzeile erstellen *************
echo "<h2>Ticket-Liste</h2>";
echo "<table border=0><tr bgcolor=\"#CCCCCC\">";
echo "<td>ID</td>";
echo "<td>Titel</td>";
echo "<td>Sprache</td>";
echo "<td>Supporter</td>";
echo "<td>Kategorie</td>";
echo "</tr>";

//****** Schleife für die Ausgabe erstellen ***********
for($j=0; $j < $num_ticket; $j++) 
  {
     mysql_data_seek ($result, $j);
     $ticket = mysql_fetch_array($result);
     echo "<tr>";
     echo "<td>$ticket[ticket_id]</td>";
     echo "<td>$ticket[ticket_name]</a></td>";
     echo "<td>$ticket[ticket_datum]</td>";
     echo "<td>$ticket[supporter_name]</td>";
     echo "<td>$ticket[kategorie_name]</td>";
     echo "</tr>";

  }
echo "</table>";
?>

</html>