Order by Random with Pagination

raouleduke

I am trying to ramdomize the results so that everyone has a chance of being on the first page, but I don't know how to hold it after the first page, when I click on page 2, it randomizes the results again, and puts some of the ones on the first page on the second. Is there a way around this:

Here is a snippet of code:

$_REQUEST['page'];

			if(!isset($_GET['page'])){ 
				$page = 1; 
			} else { 
				$page = $_GET['page']; 
			} 

			$max_results = 20; 

			$from = (($page * $max_results) - $max_results); 

			$i=0; 
			if(($i%5)==1) print "<tr valign='top'>"; 
			mysql_connect(""); 
			mysql_select_db(""); 
            $result = mysql_query( "SELECT * FROM realestateagents ORDER BY rand() LIMIT $from, $max_results");
			$check_num = mysql_num_rows($result);
			while ($a_row = mysql_fetch_array ($result) )   
			{

mrhappiness

Only select the IDs randomly and store them in a session or somewhere else

raouleduke

Can you give me a little more info, so I compile a list of all the id's in an array, and, select the first 25..... ????

Thanks in advance.

mrhappiness

session_start();
if (!empty($_SESSION['id']))
// we already have our IDs in random order
// extract 5 IDs to display per page
// $start should be 0 for the first 5 entries
  $id[] = array_slice($_SESSION['id'], $start, 5);
if (!count($id) or empty($_SESSION['id'])) {
//no IDs have been selected
  //randomly select IDs and store them in session
  $_SESSION['id'] = array();
  $r = mysql_query('SELECT id FROM tablename ORDER BY RAND()');
  while ($_SESSION['id'][] = mysl_fetch_row($r));
  array_pop($_SESSION['id']);
  // extract 5 IDs to display per page
  $id[] = array_slice($_SESSION['id'], $start, 5);
}
if (count($id)) {
// we have IDs to select from the database
  $sql = 'SELECT * FROM tablename WHERE id IN ('.implode(',', $id).')';
  $r = mysql_query($sql);
  ...
}

something like that

datona

For all of us non-guru's, does anyone have a working function that will work? I have tried to edit this one but it does not work.
I am attempting to paginate using:

select extra_id from xtrapaid WHERE extra_page='GOLFING' and extra_expire > NOW() ORDER BY rand()

Thanks for any help!

datona

Could anyone assist in helping me get the above code going?
Any help would be greatly appreciated.