Re: FN-FORUM: Problems trying to sort query results randomly, whilst splitting over several pages

date posted 9th August 2007 11:24

> The problem is that I would ideally like to sort the results randomly.
> If I do this, then the same results could come up, as on every
> subsequent page the query is re-run, randomly.

Have you tried using the optional argument for RAND(), which sets the
seed value? Keep it the same for each search query within the page set
and you should get repeatable results.

http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand

Cheers,
Neil