== Quote from Giovanni (blastingproton@gmail.com)'s article
> Hi people. I'm running this query:
> select prova,risoluzione, inizio, timediff(risoluzione,inizio) as
> delta
> from statistiche where (prova=1 and risoluzione is not null) order by
> diff asc
> but i get this result:
> risoluzione inizio diff
> 2007-04-29 15:16:55 2007-04-29 15:15:55 00:01:00
> 2007-05-02 23:25:04 2007-05-02 23:23:57 00:01:07
> 2007-05-05 20:28:21 2007-05-05 20:26:12 00:02:09
> 2007-05-05 10:21:08 2007-05-05 10:18:47 00:02:21
> 2007-04-30 16:52:50 2007-04-30 16:45:37 00:07:13
> 2007-05-05 14:23:42 2007-05-05 13:40:07 00:43:35
> 2007-04-29 23:58:17 2007-04-29 22:26:36 01:31:41
> 2007-05-05 16:35:21 2007-04-30 21:10:16 115:25:05 <------*
> 2007-05-04 12:07:43 2007-05-01 08:58:28 75:09:15
> 2007-05-04 23:43:53 2007-05-01 14:11:14 81:32:39
> Why the * row, is not ordered?
> tnx in advance...
> ah..the engine is mysql 4.1

i'd run it like this:

select prova,risoluzione, inizio, timediff(risoluzione,inizio) as
delta
from statistiche where (prova=1 and risoluzione is not null) order by risoluzione,
inizio asc

give it a shot and let us know how it does.