Welcome to Geeklog, Anonymous Tuesday, December 24 2024 @ 01:07 pm EST

Geeklog Forums

Sort stories by story number?


Status: offline

bullhakow

Forum User
Newbie
Registered: 04/28/04
Posts: 2
confused
Hey guys, i need a bit of help.

My stories on the front page are in some weird order. I've tried the panther sort order hack (even though i don't use a mac server Wink ) and that didn't work.

Is there a way to sort stories by story number instead of date, cos that'd be a simple solution...any ideas? Thanks.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
So is the date on those stories off or is it simply not sorting them correctly?

You could try changing
Text Formatted Code
$sql .= "ORDER BY featured DESC, date DESC";
 
in index.php to
Text Formatted Code
$sql .= "ORDER BY featured DESC, sid DESC";
 
but that would only be a workaround. You should try and track down the actual cause of the problem.

bye, Dirk
 Quote

Status: offline

bullhakow

Forum User
Newbie
Registered: 04/28/04
Posts: 2
Thanks, that worked a treat. I know it's a workaround but i don't have the time to be a geeklog CSI (or even a CSI from miami...)
 Quote

All times are EST. The time is now 01:07 pm.

  • 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