dubbio query e DATE_FORMAT()

[Sora88]

Non so se funziona, ma prova così

$q = "SELECT id, nick, nazione, DATE_FORMAT(data,'%d/%m/%Y') as data FROM user ORDER BY id DESC LIMIT 0, $limite";