Pagination on Random Result Set ?

[eluser]sophistry[/eluser]
maybe try not to store the entire result set in a session - it can get slow if you put too much data in a session variable because (generally speaking) sessions write/read the hard disk and are loaded on every page view where sessions are invoked.

i haven't done this but it is an interesting problem...
here's something to try:
PHP's array multisort

store an array of unique ids (primary keys from your main random recordset) in a session var.

then, just use the ids for subsequent db queries and sorting (using array_multisort() ).