team.php

<?php
include('core/class/functions.php');
    if( (isset($_GET['info'])) ) {
    $nick = $_GET['info'];
    $sql = "SELECT * FROM team WHERE nick='".mysql_real_escape_string($nick)."'";
    $entry = mysql_query($sql,$datenbank) or die(mysql_error());
    while($team = mysql_fetch_object($entry))
    {
        echo('<p><img src="content/images/avatare/'.$team->ava.'" width="120" height="120" alt="char'.$team->ava.'" class="float-left" /></p>'."\n");
        echo('<p>&nbsp;</p>'."\n");
        echo('<p>Nick: '.$team->nick.'</p>'."\n");
        echo('<p>Anzeige Name: '.$team->dname.'</p>'."\n");
        echo('<p>Kontakt: '.$team->email.'</p>'."\n");
        echo('<p>Aufgaben: '.$team->aufgaben.'</p>'."\n");
        echo('<h3>Letzte Eintr&auml;ge</h3>'."\n");
        #Hier sollen die letztens Einträge vom ausgewählten Profil sein in Tabelle "news
    }
}else{
    $sql = "SELECT * FROM team";
    $entry = mysql_query($sql,$datenbank) or die(mysql_error());
    while($team = mysql_fetch_object($entry))
    {
        echo('<p><a href="?p=team&amp;info='.$team->nick.'"><img src="content/images/avatare/'.$team->ava.'" width="120" height="120" alt="char'.$team->ava.'" class="float-left" /></p></a>'."\n");
        echo('<p>&nbsp;</p>'."\n");
        echo('<p>Nick: '.$team->nick.'</p>'."\n");
        echo('<p>Anzeige Name: '.$team->dname.'</p>'."\n");
        echo('<p>Aufgaben: '.$team->aufgaben.'</p>'."\n");
        echo('<p style="clear:both">&nbsp;</p>'."\n");
    }
}
?>