echo $row->id;

$abfrage = mysql_query('SELECT id FROM spieler WHERE id = 1'); $row = mysql_fetch_object($abfrage); echo $row->id;