• Registered: 2006-08-23
  • Posts: 1

Topic: Alpha listing / establish alpha order

Establishing alpha order to listings in categories

There are two key categories: Wanted and Available. I have searched for an alpha listing order and the closest I've got is tweaking line 113 of viewforum.php ... "topics WHERE forum_id='.$id.' ORDER BY sticky DESC".

But stickies aren't what I'm looking for.

Q: Please ... have you overcome the issue of alpha listing an Administrator's posts?

login: http://www.waste-links.net/member/login.php
user: visitor
pw:   qwer55

                 http://www.waste-links.net/gfx/alpha_listing.jpg

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Alpha listing / establish alpha order

Well, if you have a look after "ORDER BY sticky DESC" on that line, you'll notice there's one more sort condition. Just replace that so you end up with something along the lines of:

ORDER BY sticky DESC, subject ASC

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website