Posted by toonketels on March 7, 2009 at 9:26pm
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.
Downloads
Recommended releases
Development releases
Project Information
- Maintenance status: Minimally maintained
- Development status: Maintenance fixes only
- Module categories: Views
- Reported installs: 1630 sites currently report using this module. View usage statistics.
- Downloads: 8,163
- Last modified: June 26, 2012
