You could store the results in a session var to carry along the pages.
Then on the second just retrieve them.

  Or maybe a second table with this info. Give each search an ID and store
the results there. It would be easy to implement:

INSERT INTO table ('',field) SELECT field FROM table ORDER BY rand()

  The first '' is for the autoincrement that will be used as your search id.


Julio Nobrega.

Um dia eu chego lá:

Ajudei? Salvei? Que tal um presentinho?

"Georgie Casey" <[EMAIL PROTECTED]> wrote in message
> 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
> show duplicate fields and not at all show other fields.
> Does anyone know a way round this?
> --
> Regards,
> Georgie Casey
> ***************************
> Ireland's Online Film Production Directory
> ***************************

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to