<?php
    
mysql_connect("Privider","Datenbank","Kennwort");
mysql_select_db("Datenbank");    
    
    $sql = "SELECT
                sprueche.autor AS spruecheid,
                sprueche.kategorie,
                sprueche.spruch,
                sprueche.eingetragen_am,
                autor.autor_id AS autorid,
                autor.vorname,
                autor.nachname,
                autor.wikipedia,
                user.user_id AS userid,
                user.nutzername,
                user.email,
                user.website
            FROM
                sprueche
            INNER JOIN
                autor
            ON
                sprueche.autor = autor.autor_id
            INNER JOIN
                user
            ON
                sprueche.user = user.user_id
            WHERE
                sprueche.kategorie like '%" . $_POST["kategorie"]."%'
            ORDER BY
                sprueche.eingetragen_am DESC";
                
$res = mysql_query($sql);
$num = mysql_num_rows($res);

while ($dsatz = mysql_fetch_assoc($res))
 {
     echo "<small><small>";
     echo "Beitrag von ". $dsatz["nutzername"] ." | ";
     if ($dsatz["email"] != "")
      {
       echo "<a href=mailto:". $dsatz["email"] ."><small>". $dsatz["email"] ."</small></a>";
       echo " | ";
      }
     if ($dsatz["website"] != "")
      {
       echo "<a href=\"http://". $dsatz["website"] ."\" target=_blank><small>". $dsatz["website"] ."</small></a>";
       echo " | ";
      }
     echo "eingetragen am ". $dsatz["eingetragen_am"] ."";
     echo "</small></small>";
     echo "<br>";
     echo "<big><b>". $dsatz["spruch"] ."</b></big>";
     echo "<br>";
        if ($dsatz["vorname"] || $dsatz["nachname"] != "")
         {
          if ($dsatz["wikipedia"] != "")
          {
           echo "<a href=\"http://". $dsatz["wikipedia"] ."\" target=_blank><big>". $dsatz["vorname"] ." ". $dsatz["nachname"] ."</big></a>";
          }
          else
          {
           echo $dsatz["vorname"]," ",$dsatz["nachname"];
          }
         }
        else
         {
          echo "<small><small>Autor nicht bekannt</small></small>";
         } 
        echo "<br><br><br>";
      
 }

?>