transfering $result to other pages

[Anon]

I'm in the proccess of making a search page and i'm accessing a mysql database. I want the results divided up into 5's or 10's on each page. I've tried trying to transfer the mysql_result to the other pages but it doesn't work. I'm doing this using sessions and have even tried to transfer the $result via the url. On the other pages mysql_num_rows($result) doesn't return any number. I take that it means that $result isn't being transefered to the other page. Any suggestions on how to accomplish this?

[cheald]

re-query the database on each new page to get a new $result.

I'd just create a search page that takes a dynamic SQL parameter and spits out records appropriately.

[Anon]

Use the mySQL LIMIT function

Example:

SELECT * FROM tblname WHERE field-value LIMIT 0,5

Next screen

SELECT * FROM tblname WHERE field-value LIMIT 5,5

Next screen

SELECT * FROM tblname WHERE field-value LIMIT 10,5

[Anon]

if you got mysql, use the limit clause (see the other postings)

theoretically you could serialize the result array, too, then pass it via a form/querystring ... (mind the length limitations) and have it unserialized by the following script:

a.php:
$result = db_query(......);
$passresult = serialize($result);
...
<input type=hidden value="<?=$passresult ?>">
...

b.php:
$result = unserialize($passresult);
echo $result[5][9];
...
etc.