Hi, You might try something like this:
1) Create a temporary table in MySQL using the data from the table you are selecting from. 2) On each page, do your select with "order by rand() limit 10" from the temporary table 3) Do a second query to delete the rows that you just selected from the temporary table 4) On the next page, go back to step 2. Syntax for copying a table into an identical temporary table: CREATE TEMPORARY TABLE my_tbl SELECT * FROM tbl (courtesy of "MySQL" by Paul DuBois). /bsh/ Beau Lebens wrote: >could you perhaps do the select on the first page, then store the results in >a session (array) and just load different indexed portions of the resultset >each page? > >only problem there is that you wouldn't get any refreshed results while >browsing those pages - but i don't know if this matters for you or not. > >HTH > >Beau > >// -----Original Message----- >// From: Georgie Casey [mailto:[EMAIL PROTECTED]] >// Sent: Thursday, 14 March 2002 3:00 AM >// To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >// Subject: [PHP-DB] Random Selecting from mySQL >// >// >// 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 >// [EMAIL PROTECTED] >// >// *************************** >// http://www.filmfind.tv >// Ireland's Online Film Production Directory >// *************************** >// >// >// >// -- >// PHP Database Mailing List (http://www.php.net/) >// To unsubscribe, visit: http://www.php.net/unsub.php >// > -- /---------------------------------------------=[ BILLY S HALSEY ]=--\ | Member of Technical Staff, Sun Microsystems, Inc. ESP Solaris SW | | "All opinions and technical advice offered in this message are my | | own and not necessarily endorsed by my employer." | \--=[ [EMAIL PROTECTED] ]=--------------------------------------------/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
