<?php
   error_reporting(E_ALL);
//Serveradresse
$mysql_host = "localhost";
//MySQL User
$mysql_user = "root";
//MySQL Passwort
$mysql_pw = "";
//MySQL Datenbank
$mysql_dbname = "website";
//Verbindungsaufbau
$db = mysql_connect ($mysql_host, $mysql_user, $mysql_pw) or die (mysql_errno().":". mysql_error());
mysql_select_db($mysql_dbname, $db) or die(mysql_errno().":". mysql_error());

$sql = "SELECT
               nickname,
               vorname,
               nachname
        FROM
               user
        WHERE
               nickname ='".$_SESSION['nickname']."'";
echo $sql;
$result=mysql_query($sql). mysql_error();
while($row = mysql_fetch_array($result))
        echo $row['nickname'];
?>