Adds a random order handler with seed. If a constant integer argument N is specified in the sql RAND() function, it is used as the seed value, which produces a repeatable sequence of column values. This makes it possible to have paging and not having items show up twice.
It's also possible to compute a custom seed using PHP, allowing you to create pseudo randoms numbers based on variables such as the date of the day.
More info:
- MySQL: http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#funct... about RAND() and the optional integer argument.
- PostgreSQL: http://www.postgresql.org/docs/current/interactive/functions-math.html about RANDOM() and the 'select setseed' function.
Project information
- Minimally maintained
Maintainers monitor issues, but fast responses are not guaranteed. - Maintenance fixes only
Considered feature-complete by its maintainers. - 2,897 sites report using this module
- Created by swentel on , updated
- Stable releases for this project are covered by the security advisory policy.
Look for the shield icon below.
Releases
Development version: 8.x-1.x-dev updated 24 Oct 2022 at 14:03 UTC
Development version: 7.x-1.x-dev updated 6 Jul 2016 at 20:22 UTC