HomeUnityBlogs
 
 
mrpowless

Sort Articles Alphabetically in 6.1

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`
";

bad
7
good
 
 

Comments

Synergy
Synergy(positive) 106 days agocomment permalink
 
Thanks... works great.
 
bad
0
good
 
 
gameutopia
gameutopia(positive) 103 days agocomment permalink
 
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!!
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
mrpowless Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.443966150284