Random Selecting from mySQL
| From: | Georgie Casey | Date: | Wed, 13 Mar 2002 18:59:38 +0000 |
| Subject: | Random Selecting from mySQL | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-88385@lists.php.net to get a copy of this message | ||
I know how to use the "ORDER BY rand()" command on the end of queries to
randomize selection, but that's no good when you want to only display 10
results per page. The next page the user chooses, randomizes again and could
show duplicate fields and not at all show other fields.
Does anyone know a way round this?
--
Regards,
Georgie Casey
webmaster@filmfind.tv
***************************
http://www.filmfind.tv
Ireland's Online Film Production Directory
***************************