random within a limit script

[phpbuilderfan]

Hi there folks, got a wierd one here.

Im generating a mysql query with a limit.

IE 20 records.

1->10 on one page
10->20 on the next

I am using select * from table order by rand() limit 0,10

With this particular method it randomizes all records returned but only shows 10

Then when i click on the next link for 10->20
It shows 10 more random records from the result set, not 10 new ones.

So what i mean is, it grabs 10 records at a time, but because it shuffles them all before displaying, each page of 10 is random and not 10 records randomized, then the next 10 randomized

Is there a smart person out there who can help me get
10 records randomized, then the next 10 randomized

not 20 records randomized, and displayed 10 at a time?

Thanks in advance!

[LordShryku]

If I understand right, you want to pull the first ten records, then just display them randomly. Then pull next ten records, and display those randomly? I'd suggest not using the rand() order in the SQL. Just select with your LIMIT 0,10, put the results into an array, and use [man]array_rand[/man] to display them.