The secure CMS.

Welcome to Geeklog, Anonymous Saturday, December 28 2024 @ 06:23 am EST

Geeklog Forums

Sort

 New Topic  Post Reply
 04/30/04 06:09am (Read 2,025 times)  

GeeKnerd

Anonymous
Hi all,

Anyone know if its possible to sort the stories. Want to sort them by alpha and not by date, or do the sorting myself... Anyone knows how? thanks, Smile
 Quote
 04/30/04 09:42am  
Status: offline

Turias

Forum User
Full Member
Registered: 10/20/03
Posts: 807
The sorting is all done by the following line in index.php:

Text Formatted Code
$sql .= "ORDER BY featured DESC, date DESC";
 


Change that SQL to sort however you wish.
 Quote
 04/30/04 01:01pm  

sort

Anonymous
Great ty, but is it possible for you to give the "code" to sort alphabetically?
 Quote
 04/30/04 01:36pm  
Status: offline

Turias

Forum User
Full Member
Registered: 10/20/03
Posts: 807
What do you want to sort by? The story title?
 Quote
 04/30/04 02:36pm  

Sort

Anonymous
Yes Smile
 Quote
 04/30/04 02:37pm  

sort

Anonymous
Unless its possible to sort them manually?
 Quote
 04/30/04 03:14pm  
Status: offline

Turias

Forum User
Full Member
Registered: 10/20/03
Posts: 807
Change it to

Text Formatted Code
$sql .= "ORDER BY featured DESC, title ASC";

 
 Quote
 New Topic  Post Reply
All times are EST. The time is now 06:23 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content