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 Modules Support forums / 
  3. Module usage questions 
  4.  / Pull random quotes from RM Myfolder
Register
11
tallpaul
Re: Pull random quotes from RM Myfolder

  • 2011/4/13 16:55

  • tallpaul

  • Just popping in

  • Posts: 3

  • Since: 2008/7/11


Quick, more simple fix here...
In the line:
le="color: #000000"><?php $result = $db->query("SELECT * FROM ".$db->prefix("rmmf_works")." ORDER BY id_w DESC LIMIT 0,$options[0]");

You should be able to change the
le="color: #000000"><?php ORDER BY id_w DESC

to simply
le="color: #000000"><?php ORDER BY RAND()


Hope that works, enjoy!
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

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