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

Who's Online

152 user(s) are online (117 user(s) are browsing Support Forums)


Members: 0


Guests: 152


more...

Donat-O-Meter

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

Latest GitHub Commits