order by dato<dato

[Azzyh]

Hi.

I want to order the stuff that comes out of the query, by the closest dato matching and following.

 

So like if the datetime right now is:

21/21/08 3:15 pm

 

and theres a row with field "dato" that has 21/21/08 3:10 <- this should be the first on the top and then following.. hope you understand

 

i tried myself alittle:

$timenow = date('d/m/Y G:i:s');

ORDER BY dato < ($timenow)

 

but doesnt seem to be right

[Buddski]

Does "ORDER BY dato DESC" or "ORDER BY dato ASC" give you what you want..

[al]

Or you could try:

 

ORDER BY dato < NOW();

[Azzyh]

Thanks Buddski. ASC worked well for me