RE: [PHP-DB] Random Selecting from mySQL
| From: | Beau Lebens | Date: | Thu, 14 Mar 2002 00:12:51 +0000 |
| Subject: | RE: [PHP-DB] Random Selecting from mySQL | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-17664@lists.php.net to get a copy of this message | ||
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:webmaster@filmfind.tv]
// Sent: Thursday, 14 March 2002 3:00 AM
// To: php-db@lists.php.net; php-general@lists.php.net
// 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
// webmaster@filmfind.tv
//
// ***************************
// 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
//