Page 1 of 1
article order
Posted: Mon 7. Jun 2004, 15:02
by erwanpia
Hi, after reviewing the forum I can't find a clear solution to my question : how is the article order in the admin reflected in the front end, I have been playing with up / down buttons and it messes everything , also because I am using the NEWS tag to get the 10 latest articles on the website.. I just want to order my structure level and it messes everything around... Is everything based on the update date, and how can hack phpwcms to use the 'start date' instead everywhere, at least I have control on that ?....
Posted: Mon 7. Jun 2004, 18:40
by frold
Posted: Thu 19. Aug 2004, 12:03
by erwanpia
For myself, I like to control the order of articles with a date I can edit instead of the automatic timestamp . This is because I often correct articles without wanting to change their order in the front end
this is why I changed the order clause of the $sql query in get_new_articles() function in /include/inc_front/front.func.inc.php
here is the new query with the article_begin sort clause instead of article_tstamp. Not that as a result I also choose to display article_begin date instead of last modification date (article_tstamp)
Code: Select all
$sql = "SELECT article_id, article_title, article_cid, UNIX_TIMESTAMP(article_begin) AS article_date ".
"FROM ".DB_PREPEND."phpwcms_article WHERE ".
"article_public=1 AND article_aktiv=1 AND article_deleted=0 AND ".
"article_begin < NOW() AND article_end > NOW() ".
"ORDER BY article_begin DESC".$limit.";";
have a look at another thread about this :
http://www.phpwcms.de/forum/viewtopic.p ... highlight=