[www.tfw2005.com]

Originally Posted by Action-N

Can I have the Articles sort alphabeticaly instead of as summitted. Looking through the code, but wanted to get a post started here.

Thanks for this hack, I know I as well as others really needed it.

In case anyone else is searching this thread for this, I found it.

In your includes/functions_articles.php file


Find this:

$articles = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "article 
								 WHERE categoryid=$cid $moderationSQL ORDER BY dateline DESC LIMIT $start, $finish");

Replace with this:

$articles = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "article 
								 WHERE categoryid=$cid $moderationSQL ORDER BY title ASC LIMIT $start, $finish");

ASC is forwards, DESC is backwards. Datline is by post date, title is by alphabetically. I suppose you can also sort by other variables by replacing the word "title" in there, but thats up to you to figure out.

Later!