Sort Articles Alphabetically in 6.1

mrpowless posted 20th of August 2008 in Community Voice. 2 comments.

inc/classes/bxdolarticles.php

function getArticlesList( $iCategoryID )

add:

ORDER BY `Title`

to:

$sArticlesQuery = "

so it looks like:

$sArticlesQuery = "
SELECT `Title`, `Text`, DATE_FORMAT( `Date`, '{$short_date_format}' ) AS Date, `ArticlesID`, `ArticleFlag`, `ownerID`
FROM `Articles`
WHERE `CategoryID` = '{$iCategoryID}'
ORDER BY `Title`
";

 
Comments
·Oldest
·Top
Please login to post a comment.
Synergy
Thanks... works great.
gameutopia
Hey Mr. P,

Can I have the ability to sort articles based on my "mood"?

Hey Just kidding!!

This place seems a little tense lately and thought it needs a little cooling off with all the drama and all that jazz!!

2 thumbs up on this!! I'm sure this will benefit a number of members!!

As always I look forward to your next guide or idea!!
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.11277103424072