Author Topic: anyitems sort order  (Read 1520 times)

snark

  • Guest
anyitems sort order
« on: December 14, 2010, 07:20:09 PM »
somewhere around line 187

Code: [Select]
$query_items = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE section_id = '$section_id' AND active = '1' AND title != '' ORDER BY position DESC".$limit_sql);
what do I have to change to make the order go random?


Offline freeSbee

  • Moderator
  • ***
  • Posts: 1117
    • BAKERY - Website Baker shop module
Re: anyitems sort order
« Reply #1 on: December 14, 2010, 08:02:16 PM »
Google is your friend...
http://www.google.ch/search?q=mysql+random+row

Regards Christoph

snark

  • Guest
Re: anyitems sort order
« Reply #2 on: December 14, 2010, 08:51:13 PM »
Thanks, i could have thought of that myself, it works