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 // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
