WebsiteBaker Logo
  • *
  • Templates
  • Help
  • Add-ons
  • Download
  • Home
*
Welcome, Guest. Please login or register.

Login with username, password and session length
 

News


WebsiteBaker 2.13.8 is now available!


R.I.P Dietmar (luisehahne) and thank you for all your valuable work for WB
https://forum.websitebaker.org/index.php/topic,32355.0.html


* Support WebsiteBaker

Your donations will help to:

  • Pay for our dedicated server
  • Pay for domain registration
  • and much more!

You can donate by clicking on the button below.


  • Home
  • Help
  • Search
  • Login
  • Register

  • WebsiteBaker Community Forum »
  • WebsiteBaker Support (2.8.x) »
  • Bakery Shop »
  • anyitems sort order
  • Print
Pages: [1]   Go Down

Author Topic: anyitems sort order  (Read 5521 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?

Logged

freeSbee

  • Guest
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
Logged

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
Logged

  • Print
Pages: [1]   Go Up
  • WebsiteBaker Community Forum »
  • WebsiteBaker Support (2.8.x) »
  • Bakery Shop »
  • anyitems sort order
 

  • SMF 2.0.19 | SMF © 2017, Simple Machines
  • XHTML
  • RSS
  • WAP2