usa AS ..
codice:
$query = "SELECT  Nick,Stato,Simbolo,UNIX_TIMESTAMP(Attacco) AS attacco,Ultima_Arma FROM pgu WHERE Nick='$user_id'"; 
$result = mysql_query($query, $db);
$wer = mysql_fetch_array($result);
echo $wer[attacco];