I made a little mod that would display all of the records on one page (small database!) in random order. I'm not sure if it would work for you or not.
I made a "dummy" field in each record that is always empty. It's field 1 in my database. When I wanted all of them to show up in random order, I included
&random=1 in the URL. In sub query, I added the following lines. (I've kept some of the other lines in there so you can see where I put them. The ones I added are in bold print.)
Code:
LINE: while (<DB> ) {
(/^#/) and next LINE; # Skip comment Lines.
(/^\s*$/) and next LINE; # Skip blank lines.
$line = $_; chomp ($line); # Remove trailing new line.
@values = &split_decode($line);
if ($in{'random'}) {
srand ( );
$values[1]=int(rand(1000)) + 1;
$in{'sb'} = 1;
} I know this isn't what you want to do, but maybe it will give you an idea of what you do want to do.
------------------
JPD