Database date fields
Posted: Thu 7. Jul 2011, 21:49
I'm trying to change article dates - begin (article_begin), end (article_end), created (article_created). I can change the begin and end dates in the backend. I can change the begin, end, and created dates in database using phpmyadmin.
However, when I try to refer to those dates for sorting of an rss feed (in feed.ini.php), I can't seem to get it to recognize the changes - when I ask it to sort by "livedate", instead of sorting by article_begin, it sorts by article_created. And the real kicker is that even after I edit article_created to reflect a different date, it still sorts and displays the original article_created value in the feed.
Any ideas? Ultimately, I'd like the feed to be sorted by livedate.
However, when I try to refer to those dates for sorting of an rss feed (in feed.ini.php), I can't seem to get it to recognize the changes - when I ask it to sort by "livedate", instead of sorting by article_begin, it sorts by article_created. And the real kicker is that even after I edit article_created to reflect a different date, it still sorts and displays the original article_created value in the feed.
Any ideas? Ultimately, I'd like the feed to be sorted by livedate.