anyitems sort order

[snark]

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

[freeSbee]

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

Regards Christoph

[snark]

somewhere around line 187

Code Select Expand

$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?