|
I have a problem with sort by in MySQL
I want to list links DESC by date & time, so the newest links are first on the list.
My order looks like this:
ORDER BY dato, time DESC LIMIT 20
If i do that it gets all mixed up.
If i do this:
ORDER BY dato DESC LIMIT 20
It looks almost OK, but the problem is if several links are from the same day.... then it does not show right because it is not order by time also.
ps. "dato" is the DATE attribut.
|