1
Kasch
Reverse date order in Tiny Event
  • 2005/3/11 12:09

  • Kasch

  • Not too shy to talk

  • Posts: 109

  • Since: 2004/2/9 2


I would like to change the order of events in the Tiny event module. By default the module lists the oldest event first and the newest last - I wold like it to show the newest event first.

Anyone knows what lines/what file and how I should edit it? I am no good at php... I hav tried to find the parameter but the closest I get is a "date" parameter, that I believe just tells the module to sortby date (but not in which order to sort them).

2
tuxer
Re: Reverse date order in Tiny Event
  • 2005/3/21 17:04

  • tuxer

  • Just popping in

  • Posts: 2

  • Since: 2005/3/9 1


Is easy, only do:
//query Database (returns an array)

$result = $xoopsDB->queryF("SELECT id, date, date2, event, info FROM ".$xoopsDB->prefix()."_tinyevent WHERE pub='1' ORDER BY date DESC");

DESC is the word that you add

Login

Who's Online

172 user(s) are online (130 user(s) are browsing Support Forums)


Members: 0


Guests: 172


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