Hall of Fame

[hamnawa]

I was wondering if anyone could help me on how to display videos in Recent, Channels, Featured by Upload date instead of ID.

For example I have following:

Video ID:51   Title: My New Cat      Upload Date 2014-05-01
Video ID:50   Title: My last trip    Upload Date 2014-05-02

The script currently list them as:

My Last Trip (50)
My New Cat (51)

I need it to be displayed as below:

My New Cat (51)
My Last Trip (50)

[PHPVibe A.]

You will get the same videos if you change id with date.

The script lists them descending, from biggest id to lowest id, not the other way around.

You can open com/com_videolist.php and check for yourself.

Code Select Expand

ORDER BY ".DB_PREFIX."videos.id DESC

except in special cases like likes and views.

[hamnawa]

Is it because Date field in database is Text? Will that work if I convert the date filed from text to date?

[PHPVibe A.]

You will get the same videos if you change id with date.

I've already answered you on the date matter.
If you change the field structure some queries may fail.