SELECT campo1, campo2, campo3,.....FROM tabella WHERE id='$id' ORDER BY date DESC LIMIT 0,1