WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Bakery Shop => Topic started by: snark on December 14, 2010, 07:20:09 PM

Title: anyitems sort order
Post by: snark 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?

Title: Re: anyitems sort order
Post by: freeSbee on December 14, 2010, 08:02:16 PM

Google is your friend...
http://www.google.ch/search?q=mysql+random+row

Regards Christoph

Title: Re: anyitems sort order
Post by: snark on December 14, 2010, 08:51:13 PM

Thanks, i could have thought of that myself, it works