WebsiteBaker Support (2.8.x) > Bakery Shop

anyitems sort order

(1/1)

snark:
somewhere around line 187


--- Code: ---$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);
--- End code ---

what do I have to change to make the order go random?

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

Regards Christoph

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

Navigation

[0] Message Index