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.6 is now available!


Will it continue with WB? It goes on! | Geht es mit WB weiter? Es geht weiter!
https://forum.websitebaker.org/index.php/topic,32340.msg226702.html#msg226702


The forum email address board@websitebaker.org is working again
https://forum.websitebaker.org/index.php/topic,32358.0.html


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 4708 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