Bug: order for date pulls results in reverse order

[shaunmolloy]

Bug: order for date pulls results in reverse order

https://en.wikipedia.org/wiki/Sorting#Sorting_information_or_data

[SaraVieira]

Hey !

From what I see when I use order in Year as ASC I start with talks from 2008 and then it keeps going up

Is that wrong ?

[shaunmolloy]

This would show oldest first:

SELECT *
FROM table
ORDER BY created ASC
LIMIT 10

[SaraVieira]

That's what is happening if you select by year but the created at is not for the talk but for when it was added into the DB

[shaunmolloy]

Ah, so it would probably need adjusting on the frontend, so it's not confusing to the user.

[SaraVieira]

That is a good point :(

What should I call it?

[shaunmolloy]

"Date added" instead of "created at" might make more sense.

Edit: Also the date shown for the results should be in the correct order, so the DESC should show the ASC results and visa-versa.

[SaraVieira]

That date is the video year that I get from youtube :(

[SaraVieira]

And I'll change that to date added, that makes more sense :)