XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / My links in alphavetical order
Register
1
MadCat
My links in alphavetical order

  • 2007/7/17 10:26

  • MadCat

  • Just popping in

  • Posts: 72

  • Since: 2004/6/18


Hello guys!
What i have to change to the database to view my most resent links (Latest Listings) in alpavetical order?
2
christian
Re: My links in alphavetical order

  • 2007/7/17 10:38

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi,

- Edit the index.php file
- search around line 95 this string : ORDER BY date DESC
- replace with : ORDER BY l.title ASC
3
MadCat
Re: My links in alphavetical order

  • 2007/7/17 10:54

  • MadCat

  • Just popping in

  • Posts: 72

  • Since: 2004/6/18


Hi and thanks for your answer! i did that but now the titles apears from the last one in first (Z-A). I want from first in the last one (Α-Ζ).
4
markesh
Re: My links in alphavetical order

  • 2007/7/17 11:54

  • markesh

  • Just popping in

  • Posts: 79

  • Since: 2007/7/14


Hi,

instead of

ORDER BY l.title ASC

use

ORDER BY l.title DESC

(ASC = ascending, DESC = descending)


hth
markesh
First German XOOPS book: XOOPS-Buch.de
5
MadCat
Re: My links in alphavetical order

  • 2007/7/17 12:31

  • MadCat

  • Just popping in

  • Posts: 72

  • Since: 2004/6/18


Thanks a lot!!!
6
idezmax
Re: My links in alphavetical order

  • 2007/7/24 2:56

  • idezmax

  • Just popping in

  • Posts: 3

  • Since: 2007/7/24


thank


----------------------------------
http://www.idezmax.com

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

252 user(s) are online (219 user(s) are browsing Support Forums)

Members: 0

Guests: 252

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits