Hello

1.

I would like to order news inside each archived month by making the most recent date at the top rather than it read:

1st January
2nd January

Then the date we are on at the very bottom. It would be better to have it the other way around. How do I do this?

$query = $database -> dbquery( "SELECT newsstory_id, newsstory_author, newsstory_title, newsstory_seo, newsstory_description, newsstory_link, newsstory_channels, newsstory_status, newsstory_teaser, newsstory_date, newsstory_rating, newsstory_votes, newsstory_comments, newsstory_thread FROM " . DB_PREFIX . "esselbach_ct_newsstories WHERE (newsstory_date LIKE '%" . $archive_year . "-" . $archive_month . "%') AND " . $newsstory_status . " AND (newsstory_website = '0' OR newsstory_website = '" . $preferences[ 'current_website' ] . "')" . $news_expire_sql . " ORDER BY newsstory_date" );

$query = $database -> dbquery( "SELECT newsstory_id, newsstory_author, newsstory_title, newsstory_seo, newsstory_description, newsstory_link, newsstory_channels, newsstory_status, newsstory_teaser, newsstory_date, newsstory_rating, newsstory_votes, newsstory_comments, newsstory_thread FROM " . DB_PREFIX . "esselbach_ct_newsstories WHERE (newsstory_date LIKE '%" . $archive_year . "-" . $archive_month . "%') AND " . $newsstory_status . " AND (newsstory_website = '0' OR newsstory_website = '" . $preferences[ 'current_website' ] . "')" . $news_expire_sql . " ORDER BY newsstory_date DESC" );

2.

When I click 'contentteller/articles/' link it takes me to the most recent 26 articles. It doesn't show any of the other articles in my database etc.

How would I make it so that on the page it displays the 5 most recent articles and then the articles categories underneath?

Thank you!

$categories = "";

$result = $database -> dbquery( "SELECT articlecat_name, articlecat_seo, articlecat_description FROM " . DB_PREFIX . "esselbach_ct_articlescats WHERE articlecat_parentid = '1'" );

while(list($articlecat_name,$articlecat_seo,$articlecat_description) = $database -> dbrow($result))

{

 $categories .= "<a href=\"contentteller/articles_categories/" . $articlecat_seo . "html\">" . $articlecat_name . "</a><br />" . $articlecat_description . "<br /><br />";

}

<!-- Template: articles_layout_main -->

{$insert['articles_header']}

{$insert['articles_featured']}

{$insert['articles_summary']}

<br /><br />

<h1>Categories</h1>

<div class="content">

{$categories}

</div>

{$insert['articles_footer']}